White Paper

Creating Pivot Tables

 
A pivot table is really a type of summary table that's unique to Excel. Pivot tables are great for summarizing values in a table because they do magic without making you create formulas to perform the calculations. Pivot tables also let you play around with the arrangement of the summarized data. It's this capability of changing the arrangement of the summarized data on the fly simply by rotating row and column headings that give the pivot table its name.