PivotTable reports and PivotChart reports can assist you in analyzing numeric data in depth and to answer unanticipated questions about your worksheet data or an external data source. Using PivotTables is a vast and somewhat complicated topic. Here are some of the better resources to help you get started:

Create or Delete a PivotTable or PivotChart Report
From Microsoft
Working with Pivot Tables in Excel 2010 - Part 1
From YouTube - CSU Fullerton IT Training
Working with Pivot Tables in Excel 2010 - Part 2
From YouTube - CSU Fullerton IT Training
Working with Pivot Tables in Excel 2010 - Part 3
From YouTube - CSU Fullerton IT Training

Summary

PivotTable reports and PivotChart reports can assist you in analyzing numeric data in depth and to answer unanticipated questions about your worksheet data or an external data source.