New Mr Excel ON EXCEL book reveals Excel secrets

There are many people who may use Excel 40 hours a week -- those who can perform the basics all day with their eyes closed -- , who have been too busy to really delve into the menus and learn all of the new" techniques that were introduced since switching over from Lotus 1-2-3 in the 1990s. This new book will teach these people how to use Excel more efficiently.

Microsoft Excel is an incredibly feature-rich product. There are many people who may use Excel 40 hours a week -- those who can perform the basics all day with their eyes closed -- , who have been too busy to really delve into the menus and learn all of the new" techniques that were introduced since switching over from Lotus 1-2-3 in the 1990s.

If you see yourself as part of this group, then Mr Excel ON EXCEL has the solutions to your spreadsheet woes. This newest Excel bible includes over 150 easily incorporated tips, tricks and techniques that will slice hours off of your spreadsheet projects. Written by two Excel gurus for experienced Excel aficionados, the book is designed to teach ways to use Excel far more efficiently than one ever thought possible.

Here are just twelve of the unbelievable techniques revealed in the book:
• Prevent duplicate data entry (Page 26)
• Calculate hours worked when shift spans midnight (Page 66)
• Deleting unwanted links (Page 112)
• Color all cells containing formulas (Page 114)
• Prevent users from moving outside a range (Page 145)
• Add a comment to a formula (Page 155)
• Importing and refreshing data from the Internet (Page 160)
• Color row containing maximum value (Page 245)
• Copy subtotals only from a list (Page 284)
• Comparing lists without using formulas (Page 308)
• Adding a running balance column to a pivot table (Page 342)
• Combine the Vlookup function with a combo box to extract data (Page 376)

About the Authors
Joseph Rubin, CPA has over 25 years of financial experience in the accounting industry. He has served as CFO, Controller and run his CPA practice for years Joseph Rubin, CPA is an independent consultant specializing in the development of applications using Microsoft Excel for the financial industry and has instructed thousands of professionals on Microsoft Excel.

Bill Jelen is the principal behind the popular MrExcel.com website. With over 10 million annual pageviews, MrExcel.com is a leading Excel website. Along with a dedicated team of Excel gurus, Bill Jelen provides custom Excel and Access applications for hundreds of clients around the world. He is the author of Guerilla Data Analysis Using Microsoft Excel" and offers an entertaining seminar on the power tips and tricks for Microsoft Excel.

What Others Have Said About Mr Excel ON EXCEL
This book is absolutely 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. Bluntly, if you use Excel you NEED this book." -- Richie Sills, Excel MVP

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, "Mr Excel on Excel" is packed full of tips that will get you using Excel much more effectively. It will 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." -- Paddy Davies (New Zealand)

Although many other authors and publishers claim that there isn't another Excel book like theirs, in this case it is true. The book reads the way a true Help manual should, quick and to the point. There are so many tips and tricks listed in this book that every chapter can teach even the oldest of dogs new tricks. There is a nice blend of tips that speed up spreadsheet navigation, auditing and use with easy to follow examples that introduce some of the most useful features of Excel. If you have ever cringed whilst watched people using Excel inefficiently, just wait until you've mastered some of the techniques explained in this book. "Mr. Excel on Excel" is purely and simply a very well-written reference manual for those of us that need the answers quickly." -- Chris OBrien, Columbus Ohio.

Mr Excel ON EXCEL can be found in bookstores such as Barnes & Noble and Amazon.com as well as direct from the publisher for $35.95. Send to Holy Macro! Books, 13386 Judy Ave NW, Uniontown OH 44685, USA Telephone: 330-715-2875. Satisfaction is guaranteed.
-30-
Mr Excel ON EXCEL by Bill Jelen & Joseph Rubin. 6 x 9, 480 pages, 364 illustrations. ISBN 0-9724258-3-7, LC 2002-117108. $35.95. (Pub Date 4/15/2003.)
Holy Macro! Books, 13386 Judy Ave NW, Uniontown OH 44685-9310, USA Tel: (330) 715-2875, Fax: (707) 220-4510.
Email: Consult@MrExcel.com;