Excel 2003 Formulas

by John Walkenbach

Everything you need to know about * Mastering operators, error values, naming techniques, and absolute versus relative references * Debugging formulas and using the auditing tools * Importing and... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0764540734
• ISBN13: 9780764540738
• Release Date: October 2003
• Publisher: Wiley Publishing
• Length: 826 Pages
• Weight: 2.85 lbs.
• Dimensions: 1.9" x 7.4" x 9.2"

Customer Reviews

Excellent book, but there's a better choice

I've found that some reviewers say that this book doesn't give enough theory or examples are trivial or you can find that all in the Help. However, I believe that only advanced Excel users might be dissatiafied with "Excel 2003 Formulas". While that's true that it's not overloaded with the advanced theory (which is what professionals look for), it does give the beginners or intermidiate users all they need to know about formulas, and the tips and tricks offered by Walkenbach really help to discover the world of Excel. However, on the other hand if you're interested not only in formulas, but you're also planning to study the Excel as a whole then I would recommend to get the "Excel 2003 Bible" of this author. The reason is that the "Formulas..." for the most part just copy the "Bible..." which describes usage of the whole Excel and has a lot more information than the "Formulas".

Walkenbach is the best

Just an echo of previous reviewers. This is my third or fourth Walkenback Excel book - and they are all excellent. He provides more not-obvious tips and tricks than any other author - that truly impact the efficiency and usability of your spreadsheets. Great reference.

Excel 2003 Formulas

I have enjoyed Excel 2003 Formulas, as I have been able to incorporate numerous examples into my spreadsheets at work, where I improved the quality of my work and streamlined my processes. It was well worth the investment for the text as it as paid for itself in the first week. The examples are straightforward and easy to understand. The chapters are well-organized.

It's the BOM!

I use Excel non-stop for Bill Of Material (BOM) and pricing/cost analysis for manufacturing. This is by far the best publication available for the number crunching workhorse. I just find it peculiar that John decided to introduce "financial formulas" in Chapter 11. But seriously, it's loaded with boo-koos of real word examples that have made my work much more automated and easier.

Walkenbach and Excel...a great combination!

Excel 2003 Formulas provides some amazing ways to really master Excel. Walkenbach's formulas are the best! He covers operators, naming techniques, debugging, auditing, developing custom VBA functions, array formulas, imported 1-2-3 files, etc. Oh, and the CD that comes with this one is load too!