Microsoft Excel Level 3 (2003, 2007, 2010)

Working with Lists:

Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List

Working with Macros and User-defined Functions:

Recording and Using Macros
Assigning Macros
Using User-Defined Functions

Using Basic Analysis Tools:

Performing “What If” Analyses
Working with Scenarios

New Features in Excel 2007:

The Office Task Panes
Smart Tags
Smart Data Tags
New Worksheet Features
New Argument and Function Features
Other New Features and Enhancements in Excel 2007

Using Advanced Analysis Tools and External Data:

Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook