Pivot tables

Hello Kevin

Thank you for your question.

To create a pivot table:
1. Click within the columns of data you wish to be able to use within the pivot table once it has been created (including headings in the first row of the columns).
2. Go to Insert and click PivotTable and Pivot Table again.
3. Select the range of cells you want to include in the pivot table.
5. Select whether you want to create the pivot table in a new worksheet, or in the same worksheet as the data you have selected.
6. The pivot table areas appear on the page.
7. Tick/check the field/s you wish to include in the pivot table.
The fields will appear in the boxes underneath - you can drag and drop the field into different areas of the pivot table by moving fields into different boxes. Fields can be removed by unchecking them in the list of fields provided.

Amanda