COURSE NAME: Excel Pivot Tables 2007 (4060)

Course length: 1 day

Overview:

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

Prerequesite Courses:

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

Performance-based Objectives:

To learn to use pivot tables in Excel, you will:

1. Create, add fields to, and delete fields from a Pivot table.
2. Change and reorganize pivot table data, alter Pivot table field information, and refresh pivot table data.
3. Group pivot table data.
4. Create Pivot Tables based on other Pivot Tables and Charts.

Course content:

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