How to Create Excel 2007 Pivot Tables

To create a pivot table in excel, highlight the data you’d like to make a pivot table for

Highlight your data

Select the data tab.

Select data tab

Click the pivot table button.

Click on the Pivot table button

This will create a pivot table for your data.

A data table will now be displayed