Advanced Data Analysis in Excel 2003

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To provide an overview of the advanced data manipulation and analysis features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites
Familiarity with the Windows 2000 or XP user environments

Expected Duration (hours)
3.0

Lesson Objectives

Advanced Data Analysis in Excel 2003

create and modify PivotTable reports in Excel 2003.

perform calculations on PivotTable reports in Excel 2003.

create and modify a PivotTable report in Excel 2003.

create and modify PivotChart reports in Excel 2003.

create and edit a PivotChart report in Excel 2003.

use the Goal Seek and Solver tools in Excel 2003.

employ scenarios to analyze data in Excel 2003.

create data tables and outline their uses in Excel 2003.

use data-analysis tools in Excel 2003 to forecast values in a workbook.

Course Number:
113309_eng