Advanced Data Management in Excel 2003


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


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 (hours)
2.3

Lesson 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