Brilliant Microsoft Excel 2007 Pivot Tables

Paul McFedriesis well-known as a teacher of Windows and Office, particularly Excel, and is the president of Logophilia Limited, a technical writing company. Paul has been working with spreadsheets for more than 20 years and has been developing Excel solutions since the late 1980s. Now primarily a writer, Paul has written more than 50 books that have sold more than three million copies worldwide. These books include Microsoft Office Access 2007 Forms, Reports, and Queries; Tricks of the Microsoft Office 2007 Gurus (all from Que); and Microsoft Windows Vista Unleashed (Sams).

Introduction



Pivot Table Fundamentals
Creating a Basic Pivot Table
Customising a Pivot Table
Controlling the Way You View Your Pivot Data
Performing Calculations Within Your Pivot Tables
Using Pivot Charts and Other Visualizations
Analysing Disparate Data Sources with Pivot Tables
Sharing Pivot Tables with Others
Working with and Analyzing OLAP Data
Enhancing Your Pivot Table Reports with Macros
Using VBA to Create Pivot Tables
Common Pivot Table Issues and Questions

A Finding Pivot Table Commands on the Ribbon

Index