Show me how to create pivot tables in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I want to create reports that show aggregate data for a large number of rows without having to manually calculate all the values.

Open Microsoft Excel 2007
Select the data to be used in the pivot table
Click the "Insert" tab
Click the "PivotTable" button on the "Tables" section
On the "Create PivotTable" window, click the "OK" button
On the resulting new worksheet on the "PivotTable Field List" section on the right, click the checkboxes in front of the field names to be added to the pivot table