Pivot Tables in Excel

Duration: HALF DAY

Pre-requisites:

Delegates need to have experience of using Excel

Course Objectives:

The course will cover the following features 

Course Content:

What are Pivot Tables?

Parts of a Pivot Table

Creating a simple Pivot Table: 

Formatting the Pivot Table data values

Controlling the display of empty cells

Including page fields in Pivot Tables

Pivoting the data

Grouping 

Creating more complex Pivot Tables:

Sorting and hiding data

Sorting items by values in the data area

Hiding and showing specific items

Working with totals, subtotals and calculated fields

Changing summary functions during Pivot Table creation

Adding fields to the Pivot Table

Adding subtotals

Producing data subsets 

Working with external data

Controlling formatting: 

Controlling the format of the entire table

Controlling the format of Pivot Tables

Selecting data in a Pivot Table 

Setting up the data: 

Guideline for creating a list on a worksheet

Tidying list from external sources