Pivot tables are very useful in summarizing or analyzing a set of data. This function is built into the spreadsheet software package Excel. You will just need to make sure each column of data has a unique heading. You will then highlight all of the information you want to analyze and select data from your toolbar and then select pivot table. The wizard will walk you through your final selections .