When we need to summarize our data, to compare, to reveal the patterns and relationships, and to analyze trends –> Excel has provided PIVOT TABLE to make them easier to do.
“Data” > “PivotTable and PivotChart Repot”
Here is the link how to use PivotTable
It’s different way to build Pivot Table in Ms. Excel 2003 and Ms. Excel 2007!!!….Huh!…it’s the link to Making Pivot Table in Excel 2007 (Video file): http://www.5min.com/Video/Creating-a-Pivot-Table-in-Microsoft-Excel-2007-80719218