A Complete Guide to PivotTables: A Visual Approach by Paul Cornell, Paperback | Barnes & Noble
A Complete Guide to PivotTables: A Visual Approach

A Complete Guide to PivotTables: A Visual Approach

by Paul Cornell
     
 

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

Overview

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.

Editorial Reviews

bn.com
The Barnes & Noble Review
If Excel PivotTables bedevil you, you’re not alone. They confuse practically everyone. But if you need to analyze data, they’re indispensable. Paul Cornell will teach you exactly how to use them. And if you already know the basics, he’ll help you do things you didn’t know anyone could. Cornell’s taught PivotTables successfully to thousands of people, at Microsoft’s Office Power User Corner. Now it’s your turn.

You’ll start by learning what PivotTables are, what kinds of questions they can answer, and when to use them instead of crosstabs or other features. Simply and gently, Cornell guides you through the PivotTable wizard, translating its unfamiliar terminology into something more human. (Don’t worry about source data: he provides downloadable sample files.)

You’re already ahead of most Excel users, and you’ve just begun. Cornell illuminates PivotTable “components,” showing how to use them for deeper data analysis. To solidify your skills, you’ll walk through three real-world case studies. Next, Cornell turns to PivotCharts, which can reveal insights at a glance that you’d struggle to find in numeric data.

For many businesspeople, the “holy grail” of PivotTables is analyzing multidimensional data drawn from OLAP databases. Cornell covers that from start to finish -- beginning with a crystal-clear explanation of what multidimensional data is and how it differs from “ordinary” data. You’ll learn all the OLAP jargon you need, master the PivotTable menu’s OLAP-specific commands, create multidimensional data and use it for analysis, even create offline “cubes” you can take with you.

This book applies to PivotTables in any recent version of Excel; Cornell points out the (very manageable) differences. There’s even an introduction to programming these babies with VBA. Bill Camarda, from the April 2005 Read Only

Slashdot.org
If you have any need to analyze data in Excel, you must read this book. I learned so much more about PivotTables after I read it that they are now actually useful, rather than just being something I would occasionally try out. Every chapter is packed with excellent information in an easy-to-follow format.

Product Details

ISBN-13:
9781590594322
Publisher:
Apress
Publication date:
11/04/2004
Edition description:
2005
Pages:
368
Sales rank:
1,194,184
Product dimensions:
7.50(w) x 9.00(h) x 0.76(d)

Related Subjects

Meet the Author

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >