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.
- Excel 2003 Pivot Tables (video)