Excel Pivot Tables
© Ted French
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