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.


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.

PivotTables.xlsx (50 K)

More courses available at Microsoft Office Training.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!