Working with advanced formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions

Lookups and data tables
Working with lookup functions
Using MATCH and INDEX
Creating data tables

Advanced list management
Creating subtotals
Validating cell entries
Exploring database functions
Working with data forms

Working with PivotTables and Pivot Charts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with Pivot Charts (2000 onwards)

Exporting and importing
Exporting and importing text files
Exporting and importing XML data (2003 only)
Querying external databases

Using analytical options
Working with Goal Seek and Solver
Working with the Analysis ToolPak
Working with scenarios
Working with views

Working with macros
Running and recording a macro
Working with VBA code
Function procedures

Interactive Web pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web

Excel 2003 Only
Discussing Sharepoint Workspaces
Discussing Smart Documents