Insert ->PivotTable

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

Create a PivotTable

3. Try This: Choose the data

If you selected the entire Monthly Sales sheet, Excel will display the Table or Range: 'Monthly Sales'!$A:$H

 

In words, that means "name of your spreadsheet" ! "all of the data in Column A through Column H."

 

Try This, Too: Where do you want to place the new PivotTable report? The choices are create a new PivotTable in a new worksheet or place it on an existing worksheet.

 

Select: New Worksheet.

Click OK.

 

Keep going...

 
graphic1