About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store




Scroll down to see 6 sample pages.

Book Description
Bill Jelen uses his combined experience and analytical ingenuity to de-mystify the arduous task of dealing with downloaded data. He uses real-life examples of real-life management requests, and then walks you through the maze of Excel tools and formulas that not only cuts valuable time out of the process, but teaches you in plain English how to overcome the most common analytical obstacles.

About the Author
Bill Jelen spent twelve years "in the trenches", working as a financial analyst for finance, accounting, marketing and operations departments of a $500 Million company. Armed with a half-rate reporting tool and a spreadsheet, Jelen's duties involved turning large amounts of data into analyses for the board room quickly and accurately. Working with Lotus 1-2-3 and then Microsoft Excel, Jelen honed techniques to take massive amounts of data and produce meaningful reports in record time. Jelen can entertain a room full of accountants with his "Advanced Tips and Tricks for Microsoft Excel" seminar. This edition is an in-depth look at all of the techniques discussed in the seminar.

Customer Review
This is a book that I will read, chew, and digest many times. Your real-life examples and anecdotes were excellent. The exposition on pivot tables transcends any other writing I have read about them. I have about three or four thick books on Excel. Yours pivot table writing has the most clarity and usefullness. Your book is superb and stellar. It transcends all that other stuff on the shelf at the bookstores.

Product Details
Paperback: 108 Pages + 38 Page Appendix ; Dimensions (in inches): 0.31 x 10.25 x 8
Publisher: Holy Macro! Books; ISBN 0972425802 (September 2002) Sales Rank: 2

Click here to order the book!

Sample Page 1 - Table of Contents

Sample Page 2 - Table of Contents

Sample Page 3 - Table of Contents

Sample Page 4 - Excerpt (Page 6)

Sample Page 5 - Excerpt (Page 67 - Pivot Tables)

Sample Page 6 - Excerpt (Page 100 - Remedial Reading)

Click here to order the book!

Data Files Used in the Book
This was the first book that I wrote and I was not smart enough to save the data files as I wrote. However, I now teach concepts from this book in my Excel Tip & Tricks lunchbox seminar. This contains three worksheets that contain suitable data to test subtotals, consolidation, autofilter and pivot tables.


Excel is a registered trademark of the Microsoft® Corporation.
Tickling Keys, Inc. is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.