Level 1
Excel Basics
Starting the application and getting familiar with the Excel XP interface
Navigating and selecting cells in a spreadsheet
Entering and editing data
Adding numbers
Saving your workbook information
Additional Data Entry Techniques & Using Functions
Creating basic formulas
Copying a formula with AutoFill
Recognizing the differences b/w Relative and
Absolute references
Creating basic functions
Moving/Copying Data & Formatting
Inserting rows and columns
Move and copy data
Using the AutoFill feature to complete a series of values
Formatting spreadsheet data
Spreadsheet Design & Printing
Managing workbooks
Linking cell data in different workbooks or worksheets
Spell checking your data
Setting print options
Printing your worksheets

Level 2
Database Tools
Single and Multi-level sorting
Setting custom sort options
Filtering data in a list
Using custom and multiple condition criteria when filtering
Creating automatic subtotal
Charting Data with Graphs
Creating charts in Excel
Modifying chart types and chart elements
Adding or deleting data form a chart
Printing a chart
Macros, Templates, & Customizing Techniques
Recording and running a macro
Editing a macro
Customizing toolbars
Using and creating templates
Data Analysis Tools
Importing/Exporting data
Create and modify pivot tables
Creating a database query

Level 3
Creating Complex Functions
Creating and applying names in a worksheet
Using the IF function
Nesting functions
Calculating dates
Other useful functions
Using the formula auditing tools
Complex Functions Cont. & Creating User Defined Functions
Using VLOOKUP and HLOOKUP
Using database functions
Creating User Defined functions
Using the "What If" Analysis Tools
Using the Goal Seek and Solver Tools
Consolidating data
Creating Data Tables
Using the Scenario Manager
Protecting Data and Customizing Excel
Applying Data Validation
Protecting cells, worksheets, and workbooks
Inserting comments
Using conditional formatting
Creating and using styles
Creating custom toolbars & customizing Excel