Although many people know how to use excel, not many people know how to use pivot tables. Pivot table is one of the most powerful tools when doing an analysis in Excel. Pivot Tables allow you to manipulate the data the way you want to see the results.
What is a Pivot Table?
Pivot Tables allow users summarize large data, sort, count, filter items, switch rows and columns, drag and drop fields of the data which is stored in another source – another one table or spreadsheet anything you want. You can arrange the results based on the way you want to display. When you analyze large amounts of data, with Pivot Tables you can look at the same information in many different ways. How you organize and group the data often determines whether you find or overlook important trends.
Source:
Code:
http://excel-dummies.blogspot.com/2012/02/how-to-use-pivot-tables-in-excel.html