How To Create a Pivot Table in Excel 2007

If you have a large spreadsheet with tons of data, it’s a good idea to create a Pivot Table to easily analyze data more easily. Today we take a look at creating a basic Pivot Table to better organize large amounts of data to identify specific areas.

Create a Pivot Table 

First select any cell in the worksheet that contains the data you want to create the report on. Then under the Insert tab click on the PivotTable button.

1-piv 

The PivotTable dialog box opens and the table or data range we already selected will show in that field. You can have it placed in a new worksheet or in the existing one where you will need to select the location. For our demonstration we will put it in a new worksheet because it makes things less cluttered.

3piv

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

5[ov 

Select the fields you want to include in the table by dragging them to the different boxes below. The table is built while dragging the fields into the boxes for Report Filter, Column Labels, Row Labels, and Values. This lets you move the data around so you can best organize it for your report.

5[ov

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

6pivot

While building the PivotTable it’s fully functional so you can go through and test it out, like in this example where we’re filtering the months.

7piv

So now instead of having to hunt through a bunch of data in a large spreadsheet…

8-piv

You can create a nice PivotTable for better organization and presentations.

9piv

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. As you progress in your use of Excel, you’ll find a lot of other customizations for more attractive layouts.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+