Microsoft Office Excel 2003 Expert

•

Use subtotals

•

Define and apply advanced filters

•

Group and outline data

•

Use data validation

•

Create and modify list ranges

•

Add, show, close, edit, merge, and summarize scenarios

•

Perform data analysis using automated tools

•

Create PivotTable and PivotChart reports

•

Use Lookup and Reference functions

•

Use Database functions

•

Trace formula precedents, dependents, and errors

•

Locate invalid data and formulas

•

Watch and evaluate formulas

•

Define, modify, and use named ranges

•

Structure workbooks using XML

•

Create and modify custom data formats

•

Use conditional formatting

•

Format and resize graphics

•

Format charts and diagrams

•

Protect cells, worksheets, and workbooks

•

Apply workbook security settings

•

Share workbooks

•

Merge workbooks

•

Track, accept, and reject changes to workbooks

•

Import data to Excel

•

Export data from Excel

•

Publish and edit Web worksheets and workbooks

•

Create and edit templates

•

Consolidate data

•

Define and modify workbook properties