Microsoft® Office Specialist Study Guide Office 2003 Edition

Chapter E03E-1. Organizing and Analyzing Data

The skills tested by this section of the Microsoft Office Specialist Excel 2003 Expert Exam all relate to ways that you can extract information from the data in an Excel workbook. Specifically, the following objectives are associated with this set of skills:

Objective
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 Pivot Table 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 ...