Web Sites
Jon Peltier -- Pivot Tables, Pivot Charts, and Real Charts (TechTrax Article)
This article describes how to create pivot tables and pivot charts, and how to create normal charts from pivot tables.
Debra Dalgleish's Excel Tips and Techniques -- which includes these pages of Pivot Table-related topics:
Chip Pearson --
Introduction to Pivot Tables by Harald Staff
Brief intro to Pivot Tables, explains how data should be arranged, and
has code for updating the PT automatically.
Microsoft
-- PivotTable Reports 101
Good introduction to Pivot Tables.
Microsoft
-- 25 Easy PivotTable Reports
Sample file to download, and on-line instructions
Microsoft
-- Microsoft Excel Pivot Tables
A Business Software Tip by J. Carlton Collins, CPA
Daily Dose of Excel >> Creating a Simple Pivot Table
Dick Kusleika provides a detailed pictorial view into pivot tables.
John F. Lacher CPA-- Pivot
Table Tutorial
Sample file with explanation of data layout, creating Pivot Table, and
Pivot Chart. Good examples for financial info.
De
Paul University -- Quantitative Reasoning Course -- Pivot Table Exercises
Two files for download -- sample data.
Duke
University -- Intro to Pivot Tables (pdf file)
13-page document -- good intro
CFMA -- Excel
Pivot Tables: Are You Using them to Your Advantage?
Sample file for download, 6-page pdf file with info
Baarns
Publishing -- Sample Workbook with Pivot Table Instructions
Download sample file with instructions
Universities
& Colleges Admissions Service -- Pivot Tables
All text intro to Pivot Tables
NetRide
-- Using a Pivot Table Report to Track Expenditures
Sample file for download, good instructions
Microsoft Knowledgebase Articles
Limits of PivotTables in Microsoft Excel (211517)
Outlines some of the limitations of Pivot Tables
Description of the limits of PivotTable reports in Excel (820742)
Outlines some of the limitations of Pivot Tables
HOW
TO: Optimize PivotTable Performance in Excel 2000 (273583)
Explains options in the PivotTable Wizard, and how they affect memory
usage, speed, and file size.
XL:
How to Use Grouping for Fields in a PivotTable (214259)
How to group dates, times and numbers in a Pivot Table
XL97:
Using PivotTable Calculated Fields and Calculated Items (161882)
Instructions and example for each feature
XL2000:
How to Create PivotTables from Multiple Consolidation Ranges (213947)
Describes how to create a PivotTable from multiple consolidation ranges,
with examples of how to create associated charts
|