Excel 2010 Pivot Tables (Tech 102)

I was searching for a quick tutorial on pivot tables and stumbled on this book. I spent a few hours with it and learned a great deal of to-the-point information. The author provides a link to download a sample worksheet used with all the exercises. Since you are working with a single file you only need to load it up once and you are ready to work your way through all the examples. You might also want to have some of your own data available to try each concept you learn before moving on to the next topic.Every example I tried was exactly as presented in the book so I was able to move quickly through each concept. You may not be an expert on Pivot Tables when done but you will be well on your way. This was a great find.

Although I had some knowledge of pivot tables in Excel 2003, I needed more details, now in Excel 2010, for data analysis for a QI project. Most Excel books I looked at only touched on the pivot table basics. This one provided all that I needed to do the analysis effectively. I found one possible small error regarding moving rows, wrote the author, who responded quickly and apprpriately. Highly recommended.

Presentation is basic and easy to follow. Could use more substantive examples to illustrate the power of pivot tables. A good introduction to pivot tables

Excellent book but pages 38 and 39 are completely wrong.You cannot use a calculated field that way and the best proof is using a sumifs function to try to arrive to the same result.The problem is that Microsoft in a calculated field ='unit price'*quantity is not working properly because it adds all the unit prices of Beverages Argentina and then adds all the quantities of Beverages Argentina and in a second step it multiplies.In other words, Microsoft has a different result if you insert a new revenue2 column in the source data.That means that calculated fields do not always work as expected and that is a mistake that Microsoft should solve.

Nice job. Cut through the Jargon. I have several books on Excel Pivot tables that I have struggled but could never answer the question "Why am I doing this? or Why would I want to do this?" True to the Microsoft success of marketing and failure of learning, these books try to teach you everything. This book teaches you just what you need. I wish Tim Hill would tackle Access next.

If you've never worked with pivot tables this is a great book. A great reference for those who aren't novices.

This book is a handy little guide to keep at work or at home. I use pivot table a lot at work and found this book a keeper.

Gives good overview of Pivot tables. Explained clearly how to obtain desired results. Clearly met my expectations. Very good information.