Training: Analyze data with a PivotTable

Summarize Your Data with Pivot Tables

A PivotTable is an interactive table that makes it simple to summarize and analyze large amounts of data in different ways. Download this series of videos to learn how.

Applies to:
File Size:

Inside this course:

Introduction (1:13)
Understand why PivotTables are a great way to analyze your data

Prepare the sheet and create a PivotTable (1:09)
Organize your source data and use the PivotTable tools to automatically create your PivotTable

Explore the PivotTable tools (1:28)
Learn how the PivotTable Builder relates to the rows and columns in your worksheet

Change the PivotTable summary (1:10)
Use the PivotTable Builder to see just the information you need

Change the summary function and filter (1:19)
Still not seeing what you want? Change the summary function or the filter

Format and update the PivotTable (1:22)
Fine tune your data by formatting and applying styles

Practice file

Download and use this practice file for hands-on experience while watching the video.

Excel practice file PivotTables.xlsx (50 K)

More courses available at Microsoft Office Training.