training courses in excel - Pivot table Excel 2007

Hi

Thank you for your question.

To create a pivot table in Excel 2007:

1. Select a cell in the data range you wish to create the pivot table from.
2. Go to the Insert tab, and on the left hand side of the Insert ribbon you will see a PivotTable button.
3. Choose to create your PivotTable based on a table or range
4. Choose where you want your PivotTable located (existing worksheet or new worksheet).

The PivotTable area and field list should now be displayed ready for you to create your PivotTable.

Amanda