Excel Hacks: Hacking PivotTables

PivotTables are one of Excel's most powerful attractions, though many people don't know what they do. PivotTables display and extract a variety of information from a table of data that resides within either Microsoft Excel or another compatible database type. PivotTables are frequently used to extract statistical information from raw data. One can drag around the different fields within a PivotTable to view its data from different perspectives.