Pivot Tables
What is a Pivot Table?
A pivot table is a data summarization tool found in data visualization programs such as spreadsheets (e.g. Microsoft Excel). Among other functions, they can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. Pivot tables are also useful for quickly creating cross tabs. The user sets up and changes the summary’s structure by dragging and dropping fields graphically. This “rotation” or pivoting of the summary table gives the concept its name. The term “pivot table” is a generic phrase used by multiple vendors. However, the specific form PivotTable is a trademark of Microsoft Corporation[1]. – Pivot Table wikipedia entry
Why use a Pivot Table?
When to use a Pivot Table?
Creating a Pivot Table
Advanced Features
Pivot Tables & VBA
Resources
Online tutorials
A number of online pivot table resources exist:
- A pivot table tutorial by numberGo
- A series of tutorials by John F. Lacher LLC
- Learn to use Pivot Tables in Excel 2007 to Organize Data by Productivity Portfolio
- Introduction to pivot tables by Microsoft Business Solutions
- Summary Tables by John Walkenbach
- Video Tutorials by DataPig Technologies
- Pivot table fundamental and guidelines by ozgrid.com
- How to use Panorama Pivot Tables for Google Docs
Books on pivot tables
- Excel PivotTables and Charts (Mr Spreadsheet) (ISBN 978-0471772408)
- A Complete Guide to PivotTables: A Visual Approach (ISBN 1-59059-432-0) (in-depth review at slashdot.org)
- Excel 2007 PivotTables and PivotCharts: Visual blueprint ‘ ‘ (ISBN 978-0470132319)
- Pivot Table Data Crunching (Business Solutions) (ISBN 0-7897-3435-4)