Summarize Data with Pivot Tables

Excel Pivot Tables
© Ted French

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

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.

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