PREPARING DATA AND CREATING PIVOT TABLES

Prepare Data

Create a Pivot Table from a Local Data Source

Create a Pivot Table from Multiple Local Data Sources

Create a Pivot Table from an External Data Source

ANALYZING DATA USING PIVOT TABLES

Summarize Pivot Table Data

Organize Pivot Table Data

Filter Pivot Table Data

Format a Pivot Table

Refresh and Change Pivot Table Data

WORKING WITH PIVOT CHARTS

Create a Pivot Chart

Manipulate Pivot Chart Data

Format a Pivot Chart

‍