Create a PivotTable and analyze your data

Create a PivotTable and analyze your data

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.

Applies to:
File Size:

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.