SEARCH

How-To Geek

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+

  • Published 11/12/09

Comments (14)

  1. Santo

    This is a very useful tutorial. I wish there could be an another tutorial for vlookup feature in Excel.

    Mysticgeek I am sure you are listening. :)

  2. David Levine

    Pivot tables are definitely your friend. I have used them for years because my job involves data analysis. In Excel 2007, I found that a pivot table in compatibility mode behaves a little different than one in non-compatibility mode (xlsx format). Personally, I prefer the way it behaves in compatibility mode because it’s just like Excel 2003 and it doesn’t try to add color like the 2007 version.

  3. Young Song

    The feature has,as the term fittingly implies,fascinated me. It would have been much more endearing, if there was the downloadable data file you used for this illustration so that the audience of this article actually can try this out. Or is the data available somewhere on this site, but I simply cannot see it? Thanks,

  4. Wireman Charlene

    Hey everyone, it is Thanksgiving Day! I’m enjoying my extra day off, and I am planning to doing something fun that’ll probably involve a moto trip and seeing something new in Marlin I haven’t seen yet.
    You write something new at Thanksgiving?

  5. ziaul

    yes, it is really helpful.Although i tried to create/learn about pivot table for first time yet i was able to understant it alot if not fully.

  6. VINI

    its good to learn pivot table,we are looking for still depth tutorial

  7. Seshu

    It is nice to learn about Pivot table created in Excel.

    Thanks.

  8. pacuccaro

    I am trying to find a way to get to the pivot table wizard in 2007 like the old version of excel – this new way does not let me pick my options to input the data the way i want it what is the short-cut -keyboard keys to use the pivot table wizard please (alt – something ….)

  9. June Burns

    Help!! I am draging and droping fields and numbers 1 or 0 are appearing instead of the product names I need, how can I change this?

    x

  10. Sandeep

    Thanks to help me with the pivot table query n all and it;s really helpful. :)

  11. LAKSHMI

    Thanks for helping me to learn more in excel sheet

  12. AJOY KUMAR RAI

    WHAT A NICE TUTORIAL….!

  13. karthi

    Its very helpful to me.Thanks for providing such a good explanation.

  14. karthidmk

    can u pls explain vlookup also!!!!!!!!

Enter Your Email Here to Get Access for Free:

Go check your email!