Excel 2016 Pivot Table Data Crunching (includes Content Update Program) (MrExcel Library)

The book looked like new.

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.

Good book. I got 95% of what I needed out of the first two chapters. The ONE thing that made it for me was the few pages on data normalizing (the form, format and completeness of the key pivot columns/rows). After that, it was a matter of trying and doing.Also nice, is the on-line book that comes with the purchase.

This book is easy to find information on a particular function. It is great for the beginner using pivot tables (but you must be proficient in the underlying Excel software) as well as a reference book for the advanced user.The only down side is Que's website. It was difficult to navigate. Be aware that the free web edition is a non editable HTML book. If you want something to take with you and be able to make comments and highlight you will have to buy the ebook.

I have found this book to cover everything I wanted to know about Pivot Tables. There's more about Power Pivot and PowerBI, if you are interested. If you looking for a book to help you understand this useful Excel tool, you will find it in this book. I highly recommend it.

Got some good stuff for use in teaching my classes.

The book is well written and informative. Every part of pivot tables. Too bad because it was a nice piece of software.

As Excel 2016 is with us until next year, for me it was when, not if to buy Pivot Table Data Crunching. Jelen is an essential guide to any data scientist using the Excel platform.

Comments about access to sample files not being straightforward were right.

I have been exploring Pivot Tables for a while, but not in any depth. Im only at chapter 2 at the moment, but already have improved my knowledge, and the presentation of my reports. I feel quite confident that by the end of the book, I will be able to present some structured reports.

This is the book for really understanding PivotTables. It’s clear, precise and easy to read. I learnt a lot. Love it!

Very easy to follow and I picked up loads of useful tips and tricks that I hadn't previously known

Well written, easy to follow and I'm sure I'll be using it as a reference book in the future.