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 Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.3. Apply and manipulate PivotTables