|
Pivot Table Data Crunching |  | Authors: Jelen, Bill, Alexander, Michael
Publisher: QUE
Category: eBooks
This item is no longer available
Rating:  28 reviews
Sales Rank: 144339
Format: Kindle Book
Media: Kindle Edition
Pages: 288
Number Of Items: 1
Dewey Decimal Number: 005.54
ASIN: B000OZ0N6W
Publication Date: June 21, 2005
| |
| |
| Similar Items:
| |
| Editorial Reviews:
Product Description
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. 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.
|
| Customer Reviews:
Showing reviews 1-5 of 28
 right on April 24, 2010
Jose F. Feliciano
many excellent tips that i would not have picked up elsewhere. minor downer - ordered two different books on the same day and this one took two weeks longer to receive even though both were UPS ground.
 Excellent for a relative newcomer June 30, 2009
James M. Hershey (Chicago, IL United States)
I have developed pivot tables on my own for about a year, but this book answered many questions that I couldn't answer on my own. Very clear. A good reference.
Use it as a Workbook! May 9, 2009
Mister Zer0 (Houston, TX USA)
I am very experienced programmer. However, I am not at all proficient in Excel. It is my habit to try to find books that will aid my learning curve. I found exactly what I was seeking in Pivot Table Data Crunching.
I went to the Que Publishing Site (url on the back cover) and downloaded the sample data provided there. I made my personal copies of those provided sample workbooks. By following along with every chapter, I made a worksheet that contained almost all of the quite extensive figures used in illustration in the book. I put each figure on its own worksheet and named that sheet with the same name as the illustration (Figure N.NN, etc.) The sample data is quite sufficient for this purpose. In most cases, the illustration proceed logically from one to the next so a copy of the worksheet from the previous illustration can be used as the basis for the transformation to the next illustration.
The above method of use of the work is not explicitly recommended by the authors in the text. It should be in my opinion. A thoughtful work through of Pivot Table Data Crunching using this method lead me toward a working understanding the extensive power of the pivot table reporting feature in Excel.
My time is valuable to me. I most enthusiastically and highly recommend Pivot Table Data crunching to those who wish to explore Excel's pivot tables with a view toward understanding pivot table capabilities and with a view toward directed practice in understanding pivot table mechanics including their sometimes non-intuitive features.
Pivot Table Data Crunching March 3, 2009
Grandma G (Tampa, FL)
The book arrived in great conditon for a used book. It was actually brand new for a fifth of what a new one cost. I have taken it to work to share. Thanks Lov'in it
All you Need to Know to Support Pivot Tables March 17, 2008
Santeria (Tallahassee)
The hardest aspect of supporting Excel users is finding answers for what Pivot Table users need to know for their creations. Well, this is the best and most essential book you could possibly get. I knew it was the most ideal when the trainers in the area I work wanted to use this book, and amalgamate material, well no way. This, coupled together with GUERILLA DATA ANALYSIS and many other Bill Jelen "Master Class" works make for the ideal source material; I can always say, if I don't know it, I can find it in one of the Bill Jelen/Mr Excel books.
For First time Pivot Table users who want to make the best of Office 2007 and its power, this book is the first and last stop. Your Work will be great, and your Web files will never be better.
Showing reviews 1-5 of 28
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. | |
