Create a PivotTable and analyze your data

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

PivotTable reports are a powerful way to summarize, analyze, explore, and present your data in a report. PivotTables can help you make sense of your data, especially when you have a lot of it. This course shows you how to create PivotTables automatically and manually and how to sort, filter, summarize, calculate, and analyze your PivotTable data.

Inside this course:

Create a PivotTable and analyze your data (1:35)
Learn what a PivotTable and PivotCharts are and how you can use them to summarize and analyze data in Excel 2013.

Create a PivotTable report manually (5:36)
Create a manual PivotTable if you prefer to design the PivotTable yourself. Here's how.

Sort, filter, summarize, and calculate your PivotTable data (4:07)
You can analyze PivotTable data in many ways, including sorting to quickly see trends. We’ll also look at how to filter, summarize and calculate your data.

Use slicers, timelines, and PivotCharts to analyze your PivotTable data (3:52)
Filter your PivotTable data with slicers and timelines, and see what filters are applied. PivotCharts visually show your PivotTable, making trends easier to see.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!