Pivot Table Data Crunching (Paperback)

~ (Author), (Author) "Imagine that Excel is a large toolbox that contains different tools at your disposal..." (more)
Key Phrases: pivot cache, using pivot charts, formula input box, New England, Printer Sale, Shenandoah Valley (more...)

Editorial Reviews

Review

Excel users may already be aware of the power of pivot tables, which allow summarization of 50,000 rows of data with one click of the mouse – but many user's guides don't begin to touch upon its powerful features. PIVOT TABLE DATA CRUNCHING provides a tutorial which promises users and prior Excel fans the ability to get up to speed quickly, using real-world examples such as how to highlight productivity channels and produce meaningful reports. An excellent business guide.

--California Bookwatch, 10/1/06

Product Description

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

See all Editorial Reviews

Product Details

• Paperback: 288 pages
• Publisher: Que (July 1, 2005)
• Language: English
• ISBN-10: 0789734354
• ISBN-13: 978-0789734358
• Product Dimensions: 9 x 7.3 x 0.7 inches
• Shipping Weight: 8 ounces (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (27 customer reviews)
• Amazon.com Sales Rank: #58,302 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #3 in	Books > Business & Investing > Management & Leadership > Systems Analysis
  #11 in	Books > Health, Mind & Body > Exercise & Fitness > Alexander Technique
  #58 in	Books > Computers & Internet > Software > Spreadsheets

Customer Reviews

Most Helpful Customer Reviews

36 of 36 people found the following review helpful:

5.0 out of 5 stars An excellent book for both all the newbie and expert alike., December 27, 2005

By	Darryl Collins "darklydrawl" (Melbourne - Australia) - See all my reviews

Amazon Verified Purchase

On the Excel Developer Mailing list that I subscribe to there are many talented and generous people whom freely share their Excel knowledge and experience with others less skilled. Numerous of them are MVP's.

Now when folks like Bob Umlas and Jon Peltier (whom are MVP Excel experts in their own rights) say a book is worth looking at, well, I definitely am keen to check it out.

Bill "Mr. Excel" Jelen and Michael Alexander's book on getting the best out of Pivot tables was recommended to me by Jon Peltier (http://peltiertech.com/ ) and what a great piece of advice it turned out to be.

Pivot table are one of Excel's most powerful features, and yet many users never harness the potential and power of this wonderful tool. I use pivot tables a lot and thought I had a good understanding of them, but this book has taken my productivity to a whole new level. Reading this book and understanding the concepts within has definitely been a "wow" experience for me.

The style of writing is excellent and extensive screenshots and notes make it easy to follow the necessary processes to quickly and painless achieve the desired outcome.

This book covers everything from the history of the Pivot table and data basics, right through to complex tasks involving calculated pivot fields, pivot charts and extracting data from external data sources such as an SQL database or OLAP cube.

Importantly the authors also explain in great detail the potential for risk and data errors and how to minimise the chances of errors being generated. A worthwhile process for anyone using excel.

Actually I loved the way the book was interesting and useful for all skill levels. Even if you had never created a pivot table before this book is very accessable and easy to follow. And for people like myself who are advanced Excel users, there is still an amazing amount of clever techniques to maximise the power of pivot tables.

As a professional excel developer this book has definitely added value to work and (more importantly) to the end products I produce for my clients. A "wow! That is great!" client is a happy client.

44 of 46 people found the following review helpful:

5.0 out of 5 stars So you think you know Pivot Tables? Learn from the Master!, November 30, 2005

By	Bob Umlas (Palisades, NY USA) - See all my reviews

I am an Excel MVP and pretty much know Excel inside out, yet I learned so many cool things from this wonderful book! I was often confused knowing the difference between calculated fields and calculated items, but this book really cleared that up for me. I can't think of any piece of using pivot tables which was either left out or glossed over. The book will make you a pivot table master! Highly recommended, whether you're a beginner or an Excel guru!

36 of 37 people found the following review helpful:

3.0 out of 5 stars Not really for advanced users, March 4, 2006

By	BlazerHorn (Alabama) - See all my reviews

I was encouraged by other reviewer's comments that this book was useful to beginners AND experts, but I disagree. I consider myself a fairly advanced user/macro developer, and was hoping this book would help me take my Pivot Table skills to another level. The book is laid out well - and DOES cover its topics thoroughly - but it is really more of a book for intermediate excel users who may have little to no experience with Pivots.