Excel 2013 Pivot Table Data Crunching (MrExcel Library)

I received this book two days ago, and am about half way through. I had NO experience with pivot tables this book has been a life saver. This book has taught me not only how to do pivot tables with excel hands on examples (that you download at Mr. Excel website) but has also taught me how to think critically, why is this important to do, or why does this need to go here and not there. This hands on and theory approach is the best way of learning new concepts. I truly believe that a 10 year old could learn how to do pivot tables with this book it is that well written. The examples are great with data cleaning all the way to VBA programing. This book I would recommend without doubt if you are in need or want to learn pivot tables. I feel confident that in less than 2 days that I will put it on a resume as a technical skill. Best $30 I have ever spent and I would consider this a great investment for your life!

I am a long term Excel user, (after many years using Lotus 123 and visicalc before that). I realized I needed to fully understand what I could do with Pivot Tables and how to make full use of the their features. This was the perfect companion for me while I was taking on a new complex excel project. While I had a rudimentary understanding of Pivots, this provided me with the extra knowledge to take my skills to the next level. Excel continues to add new features that continue our need to stay current, this worked for me. I am not sure how this book would be for a novice or beginning excel user, but if you really need to understand the power of Pivot Tables -- it is great.

This is a really thorough description and analysis of Excel pivot tables and charts, and the use of them to analyze data. Well written with plenty of practical examples of their use.Just browsing it will equip you with a broader knowledge of the wide applicability of this powerful tool. You can often eliminate dozens of lines of VBA code with their use.I learned a great deal from just the first few days of quick reads of this book. Highly recommended.

Great reference guide as well as a nice, self-training manual. Written in a way that the reader doesn't feel intimidated from all the details, as long as they have basics of excel under their belt before purchasing this manual.

The book touches on all aspects of pivot tables. I am a long time user of PTs and appreciated the insights into PTs in 2013. Not sure how useful this would be for a beginner. I would recommend one of his Excel overview books for that.

Great book, probably more for a beginner with some experience in BI and graphing. If you're an experienced BI data grapher you probably won't get too much more out of this than you would just surfing the web, searching for solutions. It's a great resource, learned much, already put lots into practice.

Great reference to have near the desk if you want to jump start pivot table skills. Allows for reader to jump around as needed or read front to back. Overall another strong addition from Mr. Excel books.

Decent book overall, but its pretty entry-level. I knew just about everything in the book just from a few Google searched on Pivot Tables.

The first half of the book details the core principles of pivot table use, including creating Pivot Tables, customizing a Pivot Table, grouping and filtering, performing calculations and using Pivot Charts. The second half includes more advanced topics such as PowerPivot and Dax, Olap cubes, and VBA.I have so far read the first half of the book and it is excellent. There are examples to go through with the supplied data (easy to download). There are enough good, easy to read screenshots to make this process easy. The topics are covered in depth but concisely, the authors have extremely detailed knowledge of the subject matter and have great clarity.Overall, if you are interested in pivot tables this book is highly recommended.

Really difficult acquiring the data files for this book,

Quick delivery good product

Very good resource on Excel Pivots. I would recommend this to anyone who uses Excel on a regular basis.

Aqui o modelador de Planilhas em Excel pode seguramente aprender e aprimorar as técnicas de modelagem de tabelas dinâmicas inteligentes. Inserindo fórmulas em Campos calculados é possível agregar soluçōes mais eficazes as suas planilhas, sem correr o risco de um usuário inexperiente e desavisado destruir suas tão queridas fórmulas. Bom demais para os desenvolvedores de soluçōes inteligentes e ágeis em Excel.