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

Insert a Pivot Table A PivotTable summarizes data and displays the results. It is a reporting tool that works very well. Here is how you start.   2: Try This: Insert a PivotTable Go to the Monthly Sales spreadsheet. Select all. Go to Insert ->Tables. Click on PivotTable.   Keep going... Insert ->Tables-> PivotTable