Macros and Custom Toolbars

1. Working with Macros
2. Custom Toolbars

Named Ranges and Lookup Functions

1. Working with Named Ranges
2. Lookup Functions

Working with Data

1. Importing Data
2. Conditional Formatting
3. Data Validation
4. Outlining

Consolidation and Linking

1. Creating a Workspace
2. Consolidating Data
3. Linking Workbooks

Group Editing

1. Sharing and Protecting
2. Working with Comments
3. Tracking Changes

Audit, Scenarios, Views and Reports

1. Auditing Tools
2. The Scenario Manager
3. Custom Views
4. The Report Manager

Data Filters, Goals and Pivot Tables

1. Data Forms
2. Filtering Data
3. Sorting and Sub-totals
4. Goal Seeker and Goal Solver
5. Pivot Tables
6. Pivot Tables on the Web