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.
To get the free app, enter your email address or mobile phone number.
Learn Excel from Mr. Excel: 277 Excel Mysteries Solved Paperback – September 28, 2005
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
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.
Top Customer Reviews
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.'
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.
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.
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.
Most Recent Customer Reviews
Mr. Jelen is probably one of the best instructors I've run across!!Published 21 months ago by Barbara Sisco
I can't tell you how many times my boss and I have referred to this book when trying to get something done in our older version of Excel. This book is easy to follow. Read morePublished on January 21, 2014 by Petey Cat
I consider myself to be an intermediate user of Excel. I like how he chose to put the figures the text refers too on the same page as the text. Read morePublished on February 3, 2010 by G. Furlong
I might be an intermediate Excel user and I love this book. It has helped me do some data analysis even the senior analyst didn't know how to do!Published on September 20, 2009 by VCD
I was hoping that this book would help me in making the type of spread sheets I need for my job as a teacher. If anything, this book confused me even more about EXCEL. Read morePublished on September 19, 2009 by lilacrose
Tips and tricks, but For Excel 2003 and before.
Arggh, I needed 2007 :(...
But upon browsing the book, it still looks great, but not for beginners. Read more
This book is filled with everything you ever wanted to know about excel. Great reference with fun tips like games and making your excel talk!Published on June 8, 2008 by Jen Y.
Not really for true beginners, but an excellent reference book for those times when one thinks to themself, "How do I do that ___ again?"Published on February 26, 2008 by Pangai