content_image/864834.jpg
Excel will automatically select the data for the pivot table. 

Excel will also automatically select New Worksheet as the destination for the pivot table. 

3. Click Ok . 

A new worksheet will be added for the pivot table. 

Initially, the spreadsheet will appear blank. 

The PivotTable Field List is located to the right. 

<img src='content_image/864834.jpg'>

4. Choose the fields to see by selecting column headers within Choose Field to Add to Report . 

You can also drag and drop a field into a Pivot table Area within the dialogue box. 

Pivot Table Areas: 

Report Filter  – Filters the entire pivot table based on fields in that area 

Column Labels  – Adds columns to the table based on fields in that area; 

Row Labels  – Adds rows to the table based on fields in that area; 

Values  – Performs an Auto Sum action in the table based on the fields in that area. 

In a pivot table, you can sort and filter like you can with any other data range. 

To Change the Summary Calculation Value: 

1. Click on any cell in the Grand Total  row 

2. Select Value Field Settings  from the menu. 

