Training: Analyze data with a PivotTable
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:
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
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.