Why use Pivot Tables?

Pivot Tables are meant to save you a ton of time!  In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations.

http://office.microsoft.com/en-us/excel-help/overview-of-pivottable-and-pivotchart-reports-HP010342752.aspx

Pivot Tables, Slicers, and other items are covered in New Horizons Excel Level 2 class and our Excel 2010 Pivot Table class.