Excel Pivot Tables
PivotTables are one of Excel's most powerful attractions, though many people don't knoww hat 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 rawdata. You can drag around the different fields within a PivotTable to view its data from different perspectives.
The rawdata for a PivotTable must be laid out in a classic table format. Row1 of the table must be headings, with related data directly underneath. The data should not contain blank columns or blank rows. Even if you aren't planning to use PivotTables, keeping your rawdata in this format makes it possible for other people to analyze your data with PivotTables.
If you have not yet delved into the world of PivotTables, you should consider doing so. As a starting point, visit http://www.ozgrid.com/Excel/default.htm and work your way through a free online tutorial for Excel PivotTables.
In this tutorial:
- Why Are They Called PivotTables
- What Are PivotTables Good For
- PivotCharts Extend PivotTables
- Creating Tables and Lists for Use in PivotTables
- PivotTable Creation
- Share PivotTables but Not Their Data
- Automate PivotTable Creation
- PivotTable Save Time with a Macro
- Move PivotTable Grand Totals
- Efficiently Pivot Another Workbook's Data