| Course |
Excel
Advanced - Pivot Tables |
| Length |
Three
hours |
| Audience |
Learn
to create and work with Pivot Tables to look at your data in a variety
of ways. Discover how to perform a variety of calculations with
Pivot Table Data. Understand how to find the underlying data that
supports a figure. Learn to save time by re-using Pivot Table Reports
as templates. Pivot Tables – a great analysis tool! |
| Prerequisites |
Participants
should use Excel regularly on an intermediate level. |
| Topics
|
Module
1: Pivot Table Basics
- Creating
Pivot Tables
- Using Filters
- Refreshing
Data
- Changing
Pivot Table Fields
- Displaying
and Hiding Data
|
|
|
Module 2: Manipulating Pivot Tables
- Changing
Pivot Table Calculations
- Creating
More Complex Calculations
- Seeing the
Underlying Data
- Changing
the Formatting
- Pivot Table
Defaults
|
|
|
Module 3: Re-Using Pivot Table Reports
- Saving Pivot
Tables
- Saving Pivot
Tables Separate from the Source Data
- Saving Pivot
Tables as Templates
- Using a
Pivot Table Template
|
