Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.
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.
Synopsis
PivotTables are powerful data analysis tools, yet most Excel users don t use them to their fullest potential. The 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.
About 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
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.
Editorials
From Barnes & Noble
The Barnes & Noble ReviewIf 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