Excel XP Training: Beginning

1. Excel XP Training: The Excel Screen
   1.1 Overview
   1.2 Screen Elements
   
2. Excel XP Training: Entering Data
   2.1 Data Entry Techniques
   2.2 AutoFill Entry Techniques
   2.3 Erasing Data
   2.4 AutoComplete
   2.5 Undo & Re-do
   
3. Excel XP Training: Entering Formulas
   3.1 Three Methods of Entering Formulas
   3.2 Repeating a Formula in Adjacent Cells
   3.3 Formulas Beyond Addition & Subtraction
   
4. Excel XP Training: Basic Excel Functions
   4.1 Summation
   4.2 Recalculating Effects & Hierarchy of Operations
   4.3 Other Functions
   
5. Excel XP Training: Formatting
   5.1 The Formatting Toolbar
   5.2 Adjusting Widths & Row Heights
   5.3 Numeric Formatting
   
6. Saving, Opening & Closing Files
   6.1 File Save & File Save As
   6.2 Opening a File
   6.3 Creating a New Workbook
   
7. Excel XP Training: The Help System
   7.1 Using the Help System
   

Excel XP Training: Intermediate

1. Excel XP Training: Changing Worksheet Layout
   1.1 Inserting Columns, Rows, & Cells
   1.2 Deleting Columns, Rows, & Cells
   1.3 Moving Cells
   1.4 Copying Cells
   
2. Excel XP Training: Additional Formatting
   2.1 Formatting Cell Attributes & Alignment
   2.2 Borders
   2.3 Numeric Formatting
   2.4 Centering Text Across Columns
   2.5 Hiding & Unhiding Columns & Rows
   
3. Excel XP Training: Printing
   3.1 Using Print Preview & Page Setup
   3.2 Printing Controls
   3.3 Using Page Break & Preview
   
4. Excel XP Training: Using Cell References
   4.1 Absolute References
   4.2 Mixed References
   
5. Excel XP Training: The Tools Options Command
   5.1 Show/Hide Gridlines & Formulas
   5.2 Recently Used File List
   5.3 Sheets in New Workbook
   5.4 Default Settings
   

Excel XP Training: Advanced

1. Excel XP Training: Adjusting Worksheet Views
   1.1 Freeze/Unfreeze Panes
   1.2 Horizontal & Vertical Split Screens
   
2. Excel XP Training: Auditing Techniques
   2.1 Using the Formula Auditing Toolbar
   2.2 Tracing Dependent Cells
   2.3 Tracing Precedent Cells
   
3. Excel XP Training: The IF & VLOOKUP Functions
   3.1 The IF Functions & Relational Operators
   3.2 Using Words in IF Functions
   3.3 Using Logical Operators
   3.4 Nested IF Functions
   3.5 Getting Data from the Table with a VLOOKUP Function
   
4. Excel XP Training: Date & Time Functions
   4.1 Using Dates as Values
   4.2 Entering a Series of Dates
   4.3 Date/Time Entry Techniques
   
5. Excel XP Training: Multi-Sheet Workbooks
   5.1 Renaming & Reordering Sheets
   5.2 Inserting & Deleting Sheets
   5.3 Moving, Copying, & Grouping Sheets
   5.4 Formulas Across Multiple Sheets
   

Return to the Excel 2000/XP Training Main Page Detailed Video Outlines Excel 2000 Training Beginning, Intermediate and Advanced Excel 2000 Training Charting, Special Topics, Databases, Tips Tricks and Shortcuts, Pivot Tables, Functions and Files and Reports Excel 2000 Training is part of the MicroSoft Office 2000 Premium Combo Sets Check out the complete list of Keystone Training Videos Frequently Asked Questions

A-Z Software Products

Excel 2000 3 Levels: Includes Beginning, Intermediate and Advanced
Excel 2000 10 Levels: Includes Beginning, Intermediate, Advanced, Charting, Special Topics, Databases, Tips Tricks and Shortcuts, Pivot Tables, Functions and Files and Reports

Excel 2000/XP Training Return Policy: You may open and view 1 DVD for "demo" purposes and still be able return the product within 15 days. Any Keystone Training Products that have more than 1 DVD opened or unsealed, are no longer covered under the 15 Day Money Back Guarantee Policy.