Microsoft Excel for PC – Pivot Tables

Module 1 – Getting Started

What you’ll learn in this training
What is a Pivot Table?
Selecting appropriate data for a Pivot Table

Module 2 – Creating & Deleting

Creating a Pivot Table
Selecting various data sources
Quick Analysis Tool
Recommended Pivot Table feature
Classic Pivot Table layout in the grid
Select different source data
Delete a Pivot Table

Module 3 – Custom Appearance & Layout

Add and remove field from a pivot table
Add and use the page field
Change the data area number format
Change how empty cells are displayed
Format a Pivot Table
Sort a Pivot Table
View data detail for an item
View detail for a data cell
Exclude row or column items from the data summary
Group Pivot Table by dates

Module 4 – Printing Options & Copying a Pivot Table

Printing a Pivot Table with column and row field
Insert page breaks after each row item
Copy a Pivot Table

Module 5 – Summarizing with Totals & Formulas

Display grand totals
Change the data summary function
Create a calculated field
Insert a calculated item
List the formulas used in a Pivot Table

Module 6 – Refreshing Data

Refreshing Pivot Table data
Refreshing data at specific time intervals

Module 7 – Pivot Charts

Create a Pivot Chart from an existing table
Create a Pivot Chart from scratch
Change the layout of a Pivot Chart
Convert a Pivot chart to a static chart

Module 8 – Sparklines & Slicers

Use sparklines and slicers
Create sparklines
Change the sparkline type
Format sparklines
View the parts of a slicer
Create a slicer
Format a slicer