Level 1
1.0 The Excel Screen
1.1 The Excel Workbook
1.2 The Task Pane
1.3 Title Bar and Menu Bar
1.4 Toolbars
1.5 Formula
1.6 Columns & Rows
1.7 Navigation
1.8 Sheet Names & the Status Bar
1.9 Mouse Pointers & Shortcut Menus
2.0 Entering Data
2.1 Data Entry Techniques
2.2 AutoFill Entry Techniques
2.3 Erasing Data
2.4 AutoComplete & Pre-selection
2.5 IP Classes
3.0 Entering Formulas
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula in Adjacent Cells
3.3 Additional Formulas
4.0 Basic Excel Functions
4.1 Summation & Averaging
4.2 Recalculating Effects
4.3 Other Functions
5.0 Formatting
5.1 The Formatting Toolbar
5.2 Adjusting Column Widths
5.3 Numeric Formatting
6.0 Saving Files
6.1 File Save or File Save As
6.2 Opening & Closing a File
6.3 Creating a New Workbook
7.0 The Excel Help System
7.1 The Excel Help System
Level 2
1.0 Changing Worksheet Layout
1.1 Inserting Columns/Rows/Cells
1.2 Deleting Columns/Rows/Cells
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Centering Text Across Columns
2.5 Hiding and Unhiding Columns & Rows
3.0 Printing
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References
4.1 Absolute References
4.2 Mixed References
5.0 The Tools Options Command
5.1 Show/Hide Gridlines
5.2 File List & New Workbook
5.3 Default Settings
6.0 Introduction to Charting-An Overview
6.1 Quick Chart Creation
6.2 Chart Types
6.3 Titles/Gridlines & Scaling
6.4 Formatting Basics
6.5 Printing & Copying Charts
Level 3
1.0 Adjusting Worksheet Views
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split Screens
2.0 Formula Auditing Techniques
2.1 Using the Formula Auditing Toolbar
2.2 Tracing Dependent Cells
2.3 Tracing Precendent Cells
3.0 The IF & VLOOKUP Functions
3.1 IF & VLOOKUP Functions Operators
3.2 Logical Operators
3.3 Nested IF Functions
3.4 Getting Data from Tables
4.0 Dates & Times
4.1 Using Dates as Values
4.2 Entering a Series of Dates
4.3 Date/Time Entry Techniques
5.0 Multi-Sheet Workbooks
5.1 Renaming Sheets
5.2 Inserting & Deleting Sheets
5.3 Moving/Copying & Grouping
5.4 Formulas across Multiple Sheets
6.0 Introduction to Database Features
6.1 Sorting Data
6.2 Creating Subtotals
6.3 Filtering
6.4 Pivot Tables
| 