Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Buy Used
$4.30
FREE Shipping on orders over $25.
Condition: Used: Good
Comment: The item shows wear from consistent use, but it remains in good condition and works perfectly. All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels.
Have one to sell? Sell on Amazon
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

4.7 out of 5 stars 79 customer reviews

See all 3 formats and editions Hide other formats and editions
Price
New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$18.00 $0.23

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more

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.
NO_CONTENT_IN_FEATURE

Image
Interested in the Audiobook Edition?
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.

Product Details

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

Customer Reviews

Top Customer Reviews

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 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have followed Bill Jelen's work closely, on his website, his tv appearances and his latest book.

I suck at numbers, and there are a lot of people like me. We need to use data crunching software, but don't have the innate understanding and comfort level that only a few can muster.

He has the ability to take dry and scary material and put it in terms that make it easy to understand and more importantly, easy to do.

I recommend this book to anyone who uses Excel regularly. At my place of business, I have been able to give some of our accounting guys, spreadsheet gunslingers so to speak, tips and short cuts they had not heard of.

Great book and a really nice guy; I have sent him emailed questions and recevied prompt and direct answers, he really cares about his mission to make Excel easy for the world.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews


Pages with Related Products. See and discover other items: mr excel