What do you think?
Rate this book
Excel 2016 Pivot Table Data Crunching
Excel® 2006 PIVOT TABLE DATA CRUNCHING
CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!
• Create, customize, and change pivot tables • Transform huge data sets into clear summary reports • Analyze data faster with Excel 2016’s new recommended pivot tables • Instantly highlight your most profitable customers, products, or regions • Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map • Use Power View dynamic dashboards to see where your business stands • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Combine multiple data sources into one pivot table • Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot • Automate pivot tables with macros and VBA About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will
• Dramatically increase your productivity–saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth . Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.
Spreadsheets Microsoft Excel 2016
CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else!
• Create, customize, and change pivot tables • Transform huge data sets into clear summary reports • Analyze data faster with Excel 2016’s new recommended pivot tables • Instantly highlight your most profitable customers, products, or regions • Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map • Use Power View dynamic dashboards to see where your business stands • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Combine multiple data sources into one pivot table • Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot • Automate pivot tables with macros and VBA About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will
• Dramatically increase your productivity–saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth . Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions.
Spreadsheets Microsoft Excel 2016
432 pages, Paperback
First published November 20, 2015
34 people are currently reading
39 people want to read
About the author
Bill Jelen
140 books79 followersBill Jelen is the host of MrExcel.com and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
His has produced over 2000 episodes of his daily video podcast Learn Excel from MrExcel.
Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for
readers all over the world.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 6 of 6 reviews
June 19, 2017
The best book I've found on truly understanding pivot tables. If this is an area of interest for you, as well, then I'd highly recommend purchasing it.
March 26, 2018
Awesome look at Pivot Tables. Starts at the very beginning but gets you to the nitty gritty pretty quickly ending with a magic trick of reusable formatting. Really helpful examples and walk throughs with all files available on the website of the publisher no key needed so feel free to buy used. Covers PowerPivot, VBA, and backward compatibility as well. Really great resource. Will look to this series again for future Excel needs.
May 3, 2019
Excellent reference book.
September 7, 2025
Classic - Foundational!
December 5, 2015
“Excel 2016 Pivot Table Data Crunching” blew me away. I can't believe that there is so much to be said about pivot tables! The audience ranges from what the book calls casual users to power users. By casual, I think they mean “comfortable with formulas.” I'm skeptical when I see such a wide range, but here it is correct. Except for the most advanced users, parts of this book are going to be too advanced for some readers. Including me. It's ok though as it is clear which parts these are.
The book is really good about showing what features are new in different versions of Excel along with the limitations in different versions. There are lots of notes, tips and case studies. There are also many recipies/how tos. It's not fluffy, but parts are conversational. I liked the part about marketings presumed influence on PowerPivot.
I learned a number of things I want to try. Some now and some when I upgrade to Excel 2016. Other features I don't have a use for, but are cool to know that they exist. The only thing I'd change is the ordering. Chapter 14 is useful even if not an advanced user. It follows some very deep chapters so a reader could stop by then.
This book is part of the Content Update Program. You register your book online and get free updates until the next edition of the book comes out. It also means that you get access to the e-book with your copy of the printed book. I also like that the account is shared with informit.com so I didn't have to re-register.
---
Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
The book is really good about showing what features are new in different versions of Excel along with the limitations in different versions. There are lots of notes, tips and case studies. There are also many recipies/how tos. It's not fluffy, but parts are conversational. I liked the part about marketings presumed influence on PowerPivot.
I learned a number of things I want to try. Some now and some when I upgrade to Excel 2016. Other features I don't have a use for, but are cool to know that they exist. The only thing I'd change is the ordering. Chapter 14 is useful even if not an advanced user. It follows some very deep chapters so a reader could stop by then.
This book is part of the Content Update Program. You register your book online and get free updates until the next edition of the book comes out. It also means that you get access to the e-book with your copy of the printed book. I also like that the account is shared with informit.com so I didn't have to re-register.
---
Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.
May 14, 2016
My read "READ IT" is a scan read excluding mainframe connectivity (n/a for me).
Found it easy to read understand and observe on first pass.
Will now use as a reference knowing the eVersion will have the updates for the evolving software. Digging in on a need's basis.
For me excellent reference text, not to say I won't top up by YouTube to get the hands on learning necessary to extract the clever & inspirational from Pivots & BI
In summary
I would buy this book again if I lent it and it didn't return.
Found it easy to read understand and observe on first pass.
Will now use as a reference knowing the eVersion will have the updates for the evolving software. Digging in on a need's basis.
For me excellent reference text, not to say I won't top up by YouTube to get the hands on learning necessary to extract the clever & inspirational from Pivots & BI
In summary
I would buy this book again if I lent it and it didn't return.
Displaying 1 - 6 of 6 reviews