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.