Excel XP: Beginner Level

• 1.0 The Excel Screen
• 1.1 Overview
• 1.2 Screen Elements

• 2.0 Entering Data
• 2.1 Data Entry Techniques
• 2.2 AutoFill Entry Techniques
• 2.3 Erasing Data
• 2.4 AutoComplete
• 2.5 Undo and Re-do

• 3.0 Entering Formulas
• 3.1 Three Methods of Entering Formulas
• 3.2 Repeating a Formula in Adjacent Cells
• 3.3 Formulas Beyond Addition & Subtraction

• 4.0 Basic Excel Functions
• 4.1 Summation
• 4.2 Recalculating Effects & Hierarchy of Operations
• 4.3 Other Functions

• 5.0 Formatting
• 5.1 The Formatting Toolbar
• 5.2 Adjusting Widths and Row Heights
• 5.3 Numeric Formatting

• 6.0 Saving, Opening and Closing Files
• 6.1 File Save and File Save As
• 6.2 Opening a File
• 6.3 Creating a New Workbook

• 7.0 The Help System
• 7.1 Using the Help System

Excel XP: Intermediate Level

• 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 & 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 & Formulas
• 5.2 Recently Used File List
• 5.3 Sheets in New Workbook
• 5.4 Default Settings

Excel XP: Advanced Level

• 1.0 Adjusting Worksheet Views
• 1.1 Freeze/Unfreeze Panes
• 1.2 Horizontal and Vertical Split Screens

• 2.0 Auditing Techniques
• 2.1 Using the Formula Auditing Toolbar
• 2.2 Tracing Dependent Cells
• 2.3 Tracing Precedent Cells

• 3.0 The IF and VLOOKUP Functions
• 3.1 The IF Functions & Relational Operators
• 3.2 Using Words in IF Functions
• 3.3 Using Logical Operators (AND & OR) with the IF Function
• 3.4 Nested IF Functions
• 3.5 Getting Data from the Table with a VLOOKUP Function

• 4.0 Date & Time Functions
• 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 & Reordering Sheets
• 5.2 Inserting & Deleting Sheets
• 5.3 Moving, Copying, & Grouping Sheets
• 5.4 Formulas Across Multiple Sheets