How to Set Up a Pivot Table
- 1). Launch Microsoft Excel and open the spreadsheet file or worksheet that you want to use to set up a pivot table.
- 2). Highlight the rows and columns that you want to include in the pivot table. Make sure every column has a label at the top.
- 3). Go to the "Insert" tab in the main toolbar.
- 4). Click the "PivotTable" button in the "Tables" section of the toolbar.
- 5). Leave the default settings in the dialog box and then press "OK" to view the pivot table layout screen.
- 6). Check the boxes next to the field names that you want to include in the pivot table. The list of available fields is located on the right side of the screen.
Source...