Excel will automatically select the data for the pivot table. Excel will also automatically select New Worksheet as the destination for the pivot table. 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.  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:  13  1. Click on any cell in the  Grand Total  row  2. Select  Value Field Settings  from the menu. 4. Choose the fields to see by selecting column headers within  Choose Field to Add to Report . 3. Click  Ok .