Excel 2000 Training: Beginning (2 Hours 16 Minutes)

1. Excel 2000 Training: The Excel Screen (32 Minutes)
   1.1 The Excel Workbook and Worksheets
   1.2 Title Bar & Menu Bar
   1.3 Toolbars
   1.4 Formula Bar
   1.5 Columns & Rows
   1.6 Navigation
   1.7 Sheet Names & the Status Bar
   1.8 Mouse Pointers & Shortcut Menus
   
2. Excel 2000 Training: Entering Data into a Worksheet (27 Minutes)
   2.1 Data Entry Techniques
   2.2 Auto-Fill Entry Techniques
   2.3 Erasing Data
   2.4 Auto Complete
   
3. Excel 2000 Training: Entering Formulas (26 Minutes)
   3.1 Three Methods of Entering Formulas
   3.2 Repeating a Formula
   3.3 Formulas Beyond Addition and Subtraction
   
4. Excel 2000 Training: Basic Functions (21 Minutes)
   4.1 Summation
   4.2 Recalculating Effects (Change one cell and five others change)
   4.3 Averages
   
5. Excel 2000 Training: Formatting (13 Minutes)
   5.1 The Formatting Toolbar
   5.2 Adjusting Column-width and Row-height
   5.3 Numeric Formatting
   
6. Excel 2000 Training: Saving, Opening & Closing Files (16 Minutes)
   6.1 File Save or File Save as
   6.2 Opening a File
   6.3 Closing a File
   6.4 Creating a new Workbook
   

Excel 2000 Training: Intermediate (2 Hours 5 Minutes)

1. Excel 2000 Training: Changing Worksheet Layout (26 Minutes)
   1.1 Inserting Columns, Rows and Cells
   1.2 Deleting Columns, Rows and Cells
   1.3 Moving Cells
   1.4 Copying Cells
   
2. Excel 2000 Training: Additional Formatting (6 Minutes)
   2.1 Formatting Cell Attributes and Alignment
   2.2 Borders
   2.3 Numeric Formatting
   2.4 Center Text across Columns
   2.5 Hiding & Unhiding Columns & Rows
   
3. Excel 2000 Training: Printing (25 Minutes)
   3.1 Using Print Preview and Page Setup
   3.2 Printing Controls
   3.3 Using Page Break Preview
   
4. Excel 2000 Training: Using Cell References (29 Minutes)
   4.1 Absolute References
   4.2 Mixed References
   
5. Excel 2000 Training: Tools Options Command (18 Minutes)
   5.1 Show/Hide Gridlines
   5.2 Show/Hide Formulas
   5.3 Recently used Files List
   5.4 Sheets in New Workbook
   5.5 Default Settings
   

Excel 2000 Training: Advanced (2 Hours 2 Minutes)

1. Excel 2000 Training: Adjusting Worksheet Views (13 Minutes)
   1.1 Freeze/Unfreeze Panes
   1.2 Horizontal & Vertical Split screen
   
2. Excel 2000 Training: Auditing Techniques (12 Minutes)
   2.1 Using the Auditing Toolbar
   2.2 Tracing Dependant Cells
   2.3 Tracing Precedent Cells
   
3. Excel 2000 Training: Using Functions (18 Minutes)
   3.1 Paste Function
   3.2 The PMT Function
   3.3 Expanding the use of standard functions
   
4. Excel 2000 Training: Logical Functions (30 Minutes)
   4.1 IF Functions and Relational Operators (> < >= <= = <> )
   4.2 Using Words in IF Functions
   4.3 Using IF Functions with Arithmetic Operators (* / + -)
   4.4 Using Logical Operators (AND & OR) with the IF Function
   4.5 Nested IF Functions
   4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
   
5. Excel 2000 Training: Date & Time Functions (21 Minutes)
   5.1 Using Dates as Values
   5.2 Entering a Series of Dates
   5.3 Date/Time entry Techniques
   
6. Excel 2000 Training: Multi-Sheet Workbooks (22 Minutes)
   6.1 Re-Naming & Re-Ordering Sheets
   6.2 Inserting and Deleting Sheets
   6.3 Moving, Copying and Grouping Sheets
   6.4 Formulas across multiple sheets
   

Return to the Excel 2000/XP Training Main Page Detailed Video Outlines Excel XP TrainingBeginning, Intermediate and Advanced Excel 2000 TrainingCharting, Special Topics, Databases, Tips Tricks and Shortcuts, Pivot Tables, Functions and Files and Reports Excel 2000 Trainingis 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.