A pivot table is a great tool for sorting and summarizing the data in a worksheet or database file.

It can automatically sort, count, and total spreadsheet data and then create a second table to display the summarized data.

Once you have finished looking at the summarized data, you can quickly re-sort your data and look at it from a totally different perspective, and all of this can be done without using functions or formulas.

Despite being so useful, many people shy away from using them, on the belief that they are hard to use. They aren't really, and once you get the hang of them, you'll use them at every opportunity.

To find out more about this handy tool, read the **Excel Pivot Table Tutorial**.

**Related Tutorial**

- Excel 2003 Pivot Tables (video)

Great post. I was checking continuously this weblog and I’m impressed! Extremely helpful information specifically the remaining part I take care of such info much. I was looking for this particular info for a long time. Thank you and best of luck.

Hi,

The tutorials posted are extremely good and easy to learn. Thanks for all the efforts put in for the learning fraternity. Knowledge is super power and it is more powerful when shared. Keep providing such good work!!!

It’s a nice tutorial and good explained. Are there also some tutorials on how to use pivot tables with two or more tables? That would be great!

You know you’ve created a good tutorial when someone named Bukkake Tube leaves a comment saying so. xD

Its good to learn and request you all to follow

I think the people making the comments might want to also check out an English grammar tutorial.

You guys are funny! Ok, back to Pivot Tables…good tutorial; very helpful. Thanks!

Pretty easy actually!! Well done and thanks for this great tutorial.

Thanks to you i have grabbed many things from this site..

Nice tutorial. Do you have tutorial that shows Pivot table with two different workbooks? Love to see the power of excel.

Thanks…Your tutorials are helpful

us there any way in Excel 2007 to perm change the pivot tabel style to classic view?

As everyone has previously stated: Thank you!

I appreciate you taking the time to offer such concise and easy to follow instructions.

Although this series is a little bit outdated, the basics for setting up your pivot table are still true. This has once (in Excel 2003 days) introduced me to the wonderful world of data analysis using pivot tables.

Additionally I must say, this is the one advanced tool every serious data analyst should master, even since it has become so much more powerful with Excel 2007 and then finally PowerPivot in Excel 2010.

Bukkake Tube! Honestly? what a username!

When I set up the pivot table as shown on pg 6 I get zeroes showing in my table. I am using Excel 2007. I assume there is some way to show the correct values. Can you tell me what I am doin wrong please?