Advanced Data Manipulation and Analysis in Excel 2002

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
245 Minutes

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