Advanced Data Management in Excel 2003

Overview/Description
To provide an overview of the advanced data management and organizational 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


140 Minutes

Objectives :

Advanced Data Management in Excel 2003

  • sort and filter data lists in Excel 2003.
  • group and outline a data list in Excel 2003.
  • subtotal data in Excel 2003.
  • subtotal, filter, and group a data list in Excel 2003.
  • use advanced mathematical, text, and database functions, and consolidate data in Excel 2003.
  • use lookup functions in Excel 2003.
  • use lookup, mathematical, and database functions in Excel 2003.


    • Course Number: 113262_eng