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.

Applies To: Excel 2013



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!

Support resources

Change language