Guerilla Data Analysis Using Microsoft Excel [Paperback]

Bill Jelen (Author)

Book Description

ISBN-10: 0972425802 | ISBN-13: 978-0972425803 | Publication Date: September 30, 2002 | Edition: 1

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Editorial Reviews

About the Author

Bill Jelen is the principal of MrExcel.com, a leading Excel web site. He provides custom Excel and Access applications for hundreds of clients and is the author of Mr Excel on Excel. He lives in Akron, Ohio.

Product Details

• Paperback: 108 pages
• Publisher: Holy Macro! Books; 1 edition (September 30, 2002)
• Language: English
• ISBN-10: 0972425802
• ISBN-13: 978-0972425803
• Product Dimensions: 11 x 8.5 x 0.3 inches
• Shipping Weight: 13.6 ounces (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #492,228 in Books (See Top 100 in Books)

More About the Author

I 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, I was responsible for turning large amounts of data into analyses for the board room quickly and accurately. Working originally in Lotus 1-2-3 and then Microsoft Excel, I honed techniques to take massive amounts of data and produce meaningful reports in record time. These techniques are spelled out in Guerilla Data Analysis Using Microsoft Excel.

In 1998, I launched MrExcel.com, which is now one of the three most popular Excel websites with 21 million annual page views. Being MrExcel is now my full-time gig. My team has developed custom applications for hundreds of clients around the world. I enjoy entertaining a room full of accountants with my 'Power Excel' seminar.

When I am not Excelling, you can find me and the family under the stars enjoying a movie at one of the many drive-in theaters that still dot northeast Ohio or kayaking on the Mogadore Resevoir.

Customer Reviews

Most Helpful Customer Reviews

24 of 25 people found the following review helpful:

5.0 out of 5 stars A MUST for Office Excel Users, April 3, 2003

By A Customer

This review is from: Guerilla Data Analysis Using Microsoft Excel (Paperback)

I was worried that this book would either be (a) over my head or would (b) give me tips that I wouldn't use. What I found was a book with Excel tips that you don't learn in even advanced Excel training, but that are simple to use and can take A LOT of time off your day-to-day Excel tasks! The author gives simple, easy, relevant examples to how to use the tools and tells you the potential pitfalls of using each tool and how to get around them. He addresses such things as Consolidating and Subtotaling with ideas for making your reports more readable.

Highly recommend for anyone using Excel in an office environment. There will be at LEAST 5 tips in this book that will make it well worth your $$.

13 of 13 people found the following review helpful:

5.0 out of 5 stars This is a Marketing Manager's Bible, November 25, 2002

By A Customer

This review is from: Guerilla Data Analysis Using Microsoft Excel (Paperback)

If you're a marketing manager -- or any kind of manager that has to look at whacked corporate data and within minutes turn it into something that people can understand -- THIS BOOK IS FOR YOU. Bill Jelen has been where you and I are today. He's taken years of real-world examples, questions, challenges and solutions and turned them into easy-to-understand "How-to's" that will slice HOURS of tedious trial-and-error off of your analysis project. Not only that, but the book has real-live support on the internet...! This means that if the project is too overhwhelming - you can just outsource it -- I mean delegate it! Thank You Mr Excel!

17 of 22 people found the following review helpful:

2.0 out of 5 stars Not what I was looking for, December 29, 2003

By 

Roger D. Dosbaugh (Boston, Massachusetts) - See all my reviews

This review is from: Guerilla Data Analysis Using Microsoft Excel (Paperback)

I read the reviews on this site, and went to buy this book. After bringing it home, I found that it was not what I expected at all. The contents were for much more specialized applications, and didn't appear to apply to the average Excel user. I've used Excel for several years, and haven't had much of a need for many of these specialized tips. I found a few things here and there that may have been helpful, but not enough to justify buying the book.

(What really surprised me is that when I brought it back to the store, the fellow at the counter gave me a funny look, and asked why I was returning it. When I replied that it just wasn't what I expected, he said that I was the third person to return that same book in the last month!)