Microsoft Exel: Manipulating Pivot Tables

Duration: 3 hours

Level: Expert

Target Audience: Personnel at all levels/ Advanced End users

Prerequisite: Participants should have at least an intermediate level of Microsoft Excel

Course Outline

Part 1 - Creating a pivot table

Part 2 - Adding fields to a pivot table

Part 3 - Rearranging a pivot table

Part 4 - Refreshing pivot table data

Part 5 - Formatting pivot tables

Part 6 - Changing field settings

Part 7 - Creating pivot charts