Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Create New PivotTables

PivotTable: Add Fields Creating a PivotTable begins by adding fields to the table. Every table calculates something: SUM, COUNT, AVERAGE, etc. In this example, we'll answer the question: What did you sell?   6. Add Fields to the PivotTable Go to the PivotTable Fields List. Select: Product.   What Do You See? Look at the new PivotTable on the left side of the spreadsheet. The Products should be displayed in the PivotTable.   Keep going... PivotTable Tools ->Analyze-> Show-> Field List