Then under the Insert tab tap on the PivotTable button.

The PivotTable dialog box opens and the table or data range we already selected will show in that field.

For our demonstration we will put it in a new worksheet because it makes things less cluttered.

How To Create a Pivot Table in Excel 2007

The PivotTable Field List opens up and the PivotTable tools become available.

snag the fields you want to include in the table by dragging them to the different boxes below.

you might arrange the view of the PivotTable Field list so it works best for you.

3piv

Hopefully this will get you started creating your own Pivot Table.

A lot of creating the table is trial and error and finding the best way to organize the data.

![5ov

![5ov

6pivot

7piv

8-piv

9piv