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

After a decade-long search I have finally found it-a practical, understandable, superb, and stellar codex which denudes Excel's cryptic power tools. With screen shots and pellucid narrative, and couched in the context of the real world, Jelen deciphers and leads us through the labyrinth of Excel's convoluted power tools.

Finally, I am the master of the data menu. I am using more functions than I had ever imagined I could use.

With bodacious, blistering clarity, Jelen provides the grand-prix exposure of how to USE pivot tables, probably Excel's most potent device. This premier explanation of pivot tables is sine qua non reading for all Excel users. The chapter on pivot tables, if read by enough people, would skyrocket white-collar productivity and spike the government statistics.

This book leaves the tomes in the dust. This is the one. Do not wait. Buy it.

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!

I've read many software manuals, and found MrExcel on Excel one of the easiest to understand books out there on ANY of the Office applications. There are so few books that cover the beginner and intermediate levels of software. You're stuck with training manuals or Microsoft books, neither of which tell you how to do things the way they're really done in the the real world. Training manuals and Microsoft books don't tell you the idiosyncracies of the software, how to get around them; and they don't tell you the best feature to use for a given situation. This book does! Kudos to Bill Jelen and Joseph Rubin for making Excel so easy to understand!

Given how many Excel books there are out there, it can't be easy to
write a good one that fills a genuine gap in the market. Nevertheless,
Jelen & Rubin have managed to do just that. Aimed primarily at the
intermediate user, "MrExcel on Excel" is packed full of tips that will
get you using Excel much
more effectively. The book will not teach you everything there is to
know
about Excel; nor will it show you how, with some fancy API programming,
you can make Excel do the washing-up and walk the dog. What it will do
is show you techniques and tricks that will speed up tasks you already
think you know how to do, and introduce you to a few that will show you
how to do things you thought couldn't be done. If you've already used
Excel and want to use it better, then buy this book - in time saved
alone it should pay for itself in under a month

Overall assessment:

"This book is absolutley jam-packed with useful tips and tricks. You will easily recoup your outlay on the book in the time savings that you will make in your first few Excel sessions after reading it."

"I've used Excel for many years and used to think that I knew pretty much all that I needed to know. I was wrong! There are so many time-saving tips in here that you will find yourself referring to it time and again - keep it near your computer."

"And its not just about working faster, its about working smarter too. We've all been in this situation I suspect - you reach a certain point in your spreadsheet design and sit there thinking 'There must be a way to do this!'. Well there probably is and its probably in this book. Typical examples include, adding a watermark to your spreadsheets, moving a minus sign from the right of a figure to the left, using the a Euro symbol."

"Bluntly, if you use Excel you NEED this book."

Good collection of workable macro ideas but beware there is a fair smatterring of untranslated German scraps throughout the samples both in the worksheets and the VBA code.

Most of the differences are idiomatic translation - example the index says: "How can I call a Macro depending on how long the Workbook has been open?" when the real translation is "How can I call a Macro depending on what time the Workbook is opened".

As the VBA code started life in German a number of code samples use German language words as variable names making it a liitle difficult at time to decipher the meaning.

The CD is easy to use but lacks an install to Hard-disk option for the frequent user but that should prove litle challenge for the level of intellect for users likely to access the code.

The code is well laid out and every module is in a separate workbook allowing simple testing and exploration of the idea. Very few of the samples failed to run as promised and most failures relate to version differences in Excel particularly with those who have already migrated to XP - and then its mainly in the samples that use various email techniques or are affected by security levels in the users Excel.

Biggest plus is the cut and paste ability as the modules are laid out well and would satisfy the requirements of the strictest code cutter.

I keep going back to it and am gradually building up a better list of what each sample really does - I guess it was hard to find a translator who was as good at translation as Excel and VBA which is the only detraction from an otherwise great product!