Author/s : Bill Jelen, Michael Alexander
Publisher : Que Publishing
Category : Other Review by : Jeanne Boyarsky
Rating : 9 horseshoes
"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 review copy of this book from the publisher for reviewing it on behalf of CodeRanch.