Learn Excel from Mr. Excel: 277 Excel Mysteries Solved and over one million other books are available for Amazon Kindle. Learn more
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Learn Excel from Mr. Excel: 277 Excel Mysteries Solved Paperback – September 28, 2005


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$39.99 $1.10

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 836 pages
  • Publisher: Holy Macro! Books (September 28, 2005)
  • Language: English
  • ISBN-10: 1932802126
  • ISBN-13: 978-1932802122
  • Product Dimensions: 10 x 7 x 2 inches
  • Shipping Weight: 3.5 pounds
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (77 customer reviews)
  • Amazon Best Sellers Rank: #1,206,232 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Bill Jelen the principal of MrExcel.com and the author of Mr. Excel on Excel and Guerilla Data Analysis Using Microsoft Excel. He lives in Uniontown, Ohio.

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

4.7 out of 5 stars
5 star
63
4 star
12
3 star
0
2 star
0
1 star
2
See all 77 customer reviews
Bill Jelen is my hero!
Peter K. Mantell
I would highly recommend it to anyone who wants to learn Excel!
Daveg65
Very informative and easy to understand!
Snowball

Most Helpful Customer Reviews

20 of 20 people found the following review helpful By John Matlock on March 14, 2006
Format: Paperback
This is one of those books that don't really contain anything new. What they do instead is present things in a way that as you read it you tend to say 'Of course, that's the way I can do that.'

For instance, suppose you want to sort a spreadsheet on only the first three digits of an account number. You turn to page 147. It says, 'Create a new column. Use the LEFT function to populate that column. Sort on the new column.' It actually show you more instruction on how to do this, but that's the idea. 'Of course, you say, how obvious.' Then why didn't you think of it first?

To make it easier to find what you're looking for, the book is broken into four sections: The Excel Environment, Calculating with Excel, Wrangling Data, Making Things Look Good. Each section then has a bunch of these 'hints & tips' I guess I'd call them. Alternatively there's a fairly complete index that is organizated alphabetically rather than functionally.

I rank this an an excellent intermediate level book. If you don't know what a spreadsheet does, you need a lower level book. If you want to learn about Macros and VBA, you want a higher level. But regardless of your level, you'll find at least a few 'Of course's.'
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By J. Rutley on November 28, 2005
Format: Paperback
This really is a book for those who work in the 'trenches'. Keep it beside you at all times no matter what your proficiency with Excel is - expert or novice. It is clear and simple in its explanation and does not suffer verbosity.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 10 people found the following review helpful By Jim Horn on November 16, 2005
Format: Paperback
The "it" I refer to is the "holy crap, I didn't know Excel could do that!" factor.

I'm a fairly advanced Excel user, but am constantly amazed by the number of great tips and tricks that Bill's passed along in this book. Simply Amazing.

Whether you're experienced or a complete newb, I'm sure you'll find this book to be a goldmine of information.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By L. Gingras CREATIONS on January 13, 2006
Format: Paperback
Not my favorite book to read but if you wanted to know about Excel! this is the book!!!! Kinda a bible for Excel. I love the Zip samples that you can download online.
[...]
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By S. Clothier on November 10, 2005
Format: Paperback
I am a PC tech/technical management type who wanted to track metrics for my staff. Because I created a spreadsheet for that purpose, I somehow became the "expert" for my entire department. I created a balanced scorecard spreadsheet template used by most of our IT departments. In the course of learning how to really use Excel, I purchased about fifteen different books on Excel. Some are excellent (particularly those by Mr. Walkenbach); but in the course of my research I encountered Mr. Excel, and his tools and hints have become the ones most useful to me on a daily basis. Sitting beside those Excel books is a binder with printouts of the weekly downloads from the book. I've greatly enjoyed reading the chapters I downloaded each week, and I knew early on I would purchase the book as soon as it was available. I did so as soon as I heard it had been printed. Mr. Jelen, you have made it possible for me, a non-programmer, to actually use Excel for improved management and reporting. My sincere thanks.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 8 people found the following review helpful By CM on November 9, 2005
Format: Paperback
This is the best written Excel book I have, loaded to the brim with everyday, useful, easy to understand instructions. I would highly recommend it!!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By Shankar on November 24, 2005
Format: Paperback
The content is very good delivered in a very simple, step by step manner. Even my mom could follow what the author is trying to say and where it is more applicable. Money worth spent!!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By Ruthann Smith on November 9, 2005
Format: Paperback
No more frustrating searches though the MS Knowledge base!!

I origingally came across Mr. Excel 38 weeks ago while searching the web for certain Excel formula and macro functions as well as brushing up on features that I don't use often. I had just taken the MS Expert certification for Excel missed a few items that I never even saw. I went back to Mr. Excel and there it was, plain as day.

That was the best day I've had regarding software (although, I wish that I had discovered it earlier). So I signed up for the preview.

WOW...so many tricks, shortcuts and ways of making things simpler. I am a very advanced Excel user and this book tops the cake!!

Another review for this mentioned finding ooohs and aaahhhs - how true it is...you'll be saying.."WOW I can do that!" and "OH that's what that does" etc.

I'm sure that you won't sit there and just look at the sections with a blank stare. The language is easy to understand. It is geared towards the user - real people - it helps you to understand what features/functions are used for, not just instructions. It also has great screen shots. Don't be overwhelmed - just take it as it is - step by step. I would suggest quickly running through the chapters to see what's there first..then you can begin actually USING and UTILIZING the software for what is and has.

I definately recommend this to EVERYONE.

It is excellent for beginners to learn the basics and useful tips and tools. As well as for advanced users.

Don't forget the website!! Another excellent reference site.

I know several family novices that will get this for the holiday!

PS. Regarding a review of this book...A few typos are the least of my concerns for a book like this - unlike if it was a Literature or Grammar book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?