Microsoft Excel 2000 Beginning (2 Hours 16 Minutes)

1. 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. 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. Entering Formulas (26 Minutes)
   3.1 Three Methods of Entering Formulas
   3.2 Repeating a Formula
   3.3 Formulas Beyond Addition and Subtraction
   
4. Basic Functions (21 Minutes)
   4.1 Summation
   4.2 Recalculating Effects (Change one cell and five others change)
   4.3 Averages
   
5. Formatting (13 Minutes)
   5.1 The Formatting Toolbar
   5.2 Adjusting Column-width and Row-height
   5.3 Numeric Formatting
   
6. 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
   

Microsoft Excel 2000 Intermediate (2 Hours 5 Minutes)

1. 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. 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. Printing (25 Minutes)
   3.1 Using Print Preview and Page Setup
   3.2 Printing Controls
   3.3 Using Page Break Preview
   
4. Using Cell References (29 Minutes)
   4.1 Absolute References
   4.2 Mixed References
   
5. 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
   

Microsoft Excel 2000 Advanced (2 Hours 2 Minutes)

1. Adjusting Worksheet Views (13 Minutes)
   1.1 Freeze/Unfreeze Panes
   1.2 Horizontal & Vertical Split screen
   
2. Auditing Techniques (12 Minutes)
   2.1 Using the Auditing Toolbar
   2.2 Tracing Dependant Cells
   2.3 Tracing Precedent Cells
   
3. Using Functions (18 Minutes)
   3.1 Paste Function
   3.2 The PMT Function
   3.3 Expanding the use of standard functions
   
4. 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. 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. 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
   

Detailed Video Outlines

Excel 2000 is part of the MicroSoft Office 2000 Premium Combo Sets
Check out the complete list of Keystone Training Videos

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.