A Complete Guide to PivotTables: A Visual Approach

Front Cover
Apress, Nov 5, 2004 - Computers - 368 pages

PivotTables are powerful data analysis tools, yet most Excel users dont use them to their fullest potential. A Complete Guide to PivotTables: A Visual Approach shows you why PivotTables are so versatile for data analysis and how you can leverage PivotTables to rapidly spot trends and make fast business decisions on mountains of data.

A series of step-by-step tutorials and plenty of sample business data will help you get productive with PivotTables quickly and easily. Whereas most books only devote a small section to PivotTables, this book covers everything about this important Excel feature. With his tremendous experience writing about Office and Excel for power users, Paul Cornell will teach you plenty about PivotTables.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

What Are PivotTables?
1
Creating PivotTables
39
Working with PivotTable Components
81
Using PivotTables in the Real World
135
Working with PivotCharts
173
Analyzing Multidimensional Data with PivotTables
227
Programming PivotTables
269
PivotTable Differences Between Excel 2000 2002 and 2003
323
Index
331
Copyright

Other editions - View all

Common terms and phrases

About the author (2004)

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.

Bibliographic information