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.

Applies To: Excel for Mac 2011

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language