2003 Excel Expert Exam Skill Standards

Organizing and Analyzing Data
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

Formatting Data and Content
Create and modify custom data formats
Use conditional formatting
Format and resize graphics
Format charts and diagrams

Collaborating
Protect cells, worksheets, and workbooks
Apply workbook security settings
Share workbooks
Merge workbooks
Track, accept, and reject changes to workbooks

Managing Data and 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

Customizing Excel
Customize toolbars and menus
Create, edit, and run macros
Modify Excel default settings