Advanced Data Manipulation and Analysis in Excel 2002

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 2002

Target Audience
End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level

Prerequisites
The Microsoft Office XP: Beginning Excel 2002 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 user environments

Expected Duration (hours)
4.1

Lesson Objectives

Advanced Data Manipulation and Analysis in Excel 2002

use macros in Excel 2002.

record and run a macro in Excel 2002.

edit and delete macros in Excel 2002.

edit a macro in Excel 2002.

assign a macro to a command button in Excel 2002.

create and modify a macro in Excel 2002.

import data from other applications into an Excel 2002 workbook.

import data from the Web into Excel 2002.

import an HTML table into Excel 2002.

export data from Excel 2002 to other applications.

export data from Excel 2002 to a web page.

create and modify PivotTable reports in Excel 2002.

create and modify a PivotTable report in Excel 2002.

perform calculations on PivotTable reports in Excel 2002.

perform PivotTable calculations in Excel 2002.

save and manipulate Excel 2002 PivotTable reports on the Web.

create and modify PivotChart reports in Excel 2002.

use the Goal Seek and Solver tools in Excel 2002.

use Solver to find a target value in Excel 2002.

use scenarios to analyze data in Excel 2002.

create a scenario in Excel 2002.

create data tables and discuss their uses in Excel 2002.

Course Number:
114635_eng