http://www.xlninja.com/2012/06/22/excel-pivot-table-tutorial/A Pivot Table in Excel is one of the most powerful tools available for analysis of large sets of data.