COURSE NAME: Excel Pivot Tables 2003 (4060)

Course length: 1 day

Overview:

In-depth training in the use of Microsoft Excel Pivot Tables.

Prerequesite Courses:

• Excel 2003 - Level 1 (4060) or equivalent knowledge
• Excel 2003 - Level 2 (4060) or equivalent knowledge
• Excel 2003 - Level 3 (4060) or equivalent knowledge

Performance-based Objectives:

• Create, add fields to, and delete fields from a pivot table.
• Change and reorganize pivot table data, alter pivot table field information, and refresh pivot table data.
• Discuss grouping pivot table data.

Course content:

• Creating pivot tables
• Modifying pivot tables
• Grouping and summarizing data in a pivot table