Goodreads helps you keep track of books you want to read.
Start by marking “Pivot Table Data Crunching” as Want to Read:
Pivot Table Data Crunching
Enlarge cover
Rate this book
Clear rating
Open Preview

Pivot Table Data Crunching

3.85  ·  Rating Details ·  33 Ratings  ·  4 Reviews

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, and Michael Alexander, a

Paperback, 274 pages
Published July 1st 2005 by Que (first published June 20th 2001)
More Details... edit details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about Pivot Table Data Crunching, please sign up.

Be the first to ask a question about Pivot Table Data Crunching

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

(showing 1-30)
filter  |  sort: default (?)  |  Rating Details
Nov 23, 2007 Dan rated it it was amazing
Recommends it for: anyone who analyzes data and has to present it.
Recommended to Dan by: Dan Phelps
A friend of mine who is an Excel consultant said, "The answer is a pivot table; now what is the question?" I was acquainted with the primitive capability of pivot tables in early versions of Excel, but I did not realize how powerful they have become. I am now finding many uses for them. Jelen has written an excellent learning tool and resource book. He has most of the examples in the book available in completed Excel workbooks that can be downloaded from a web site for free. The reader can conce ...more
Jun 19, 2010 Jon rated it really liked it
Shelves: technical
Great introductory book for pivot tables/charts for beginners. Also, some gems for intermediate users.

The book was put together very well and was easy to read.

My only disappointment was that it wasn't as advanced as I was hoping.
Bill Jelen
Sep 29, 2007 Bill Jelen added it  ·  (Review from the author)
Recommends it for: analysts
Shelves: excel, pivot, que
Pivot tables are Excel's most powerful feature. This book shows you how to create a pivot table to summarize 50,000 rows of Excel data.
Nov 10, 2016 Tatiana rated it it was amazing  ·  review of another edition
Very good book for everyone who is starting with pivot tables. Easy, comprehensible and with hands-on approach.
Naveed rated it did not like it
May 20, 2013
Russell L Brown
Russell L Brown rated it liked it
Jan 29, 2014
Angela rated it really liked it
Dec 22, 2010
Ronald rated it it was amazing
Apr 03, 2014
Tom Curran
Tom Curran rated it liked it
Jun 12, 2015
Valerie Arnold
Valerie Arnold rated it liked it
Jul 03, 2014
Urbanite619 rated it it was amazing
Sep 23, 2014
Nathalie rated it it was amazing
Feb 04, 2012
Chris rated it really liked it
Oct 30, 2011
Enver Hoxha
Enver Hoxha rated it really liked it
May 25, 2013
John Gerbracht
John Gerbracht rated it really liked it
Jan 01, 2017
Gayle Werner
Gayle Werner rated it it was ok
Dec 23, 2013
Cathy D
Cathy D rated it it was ok
Aug 14, 2014
Sujan rated it it was ok
Sep 14, 2013
Nasser rated it liked it
Jul 19, 2013
John Rondthaler
John Rondthaler rated it liked it
Nov 14, 2016
Matthew rated it it was amazing
Jun 02, 2015
Diana Tanase
Diana Tanase rated it it was amazing
Sep 25, 2015
Hendrik Du
Hendrik Du rated it really liked it
Jun 04, 2016
Allan Ramirez
Allan Ramirez rated it it was amazing
Mar 08, 2016
Winter rated it really liked it
Feb 11, 2012
Jon Von der heyden
Jon Von der heyden rated it it was amazing
Jul 20, 2013
Robert rated it really liked it
May 07, 2008
Tyler rated it liked it
Oct 28, 2011
Elisabeth rated it really liked it
Dec 25, 2011
Tim Howrey
Tim Howrey rated it really liked it
May 14, 2014
« previous 1 next »
There are no discussion topics on this book yet. Be the first to start one »

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »
Bill Jelen is the host of and the author of 50 books about Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and Guerrilla Data Analysis Using Microsoft Excel. He writes monthly Excel columns for Strategic Finance magazine.
He has been awarded the MVP in Excel for 10 years by Microsoft.
He has made over 60 guest appearances on TV’s Call for Help with Leo Lapor
More about Bill Jelen...

Share This Book