Creating a PivotTable® Use File: Excel PivotTable Class File Microsoft® Excel PivotTable® feature organizes, summarizes, and analyzes your data to reveal its meanings. PivotTable reports: offer comparisons, reveal patterns and relationships, and analyze trends.

Each PivotTable report gives you a different view of your data, answering your questions on the spot, and is customized to your purposes. Once you have your questions in mind, Excel makes it easy to get answers. First, a wizard takes us step-by-step in preparing the data for a new view. Next, you drag and drop the data from a list into a new PivotTable report view.

Benefits of PivotTable Reports
Pivot data around – moving parts of the table structure to summarize the data Easily adjustable and customizable PivotTables can quickly become PivotCharts

Source Data
We must become familiar with the source data to produce successful PivotTables. Let’s look at a sample of our worksheet

Download