Microsoft Excel 2002 Formulas (With CD-ROM) (Paperback)

by John Walkenbach (Author) "MICROSOFT EXCEL HAS BEEN REFERRED TO as "the best application ever written for Windows..." (more)
Key Phrases: following array formula, array formula returns, multicell array formula, End Function, Define Name, Single Family (more...)

Editorial Reviews

Product Description
Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications. This book answers virtually all formula-related questions posed in Excel newsgroups on the Internet. Plus, it contains a coupon for Walkenbach's Professional Power Utility Pak.

From the Back Cover
Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, this one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-so-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets — and make the most of Excel. Your Road Map to High-Performance Excel Formulas

• Get a concise overview of Excel's many features, including cell formatting, analysis tools, and protection options
• Master basic formula facts — including absolute vs. relative references, operators, error values, naming techniques, and more
• Get practical tips on using Excel's worksheet functions in your formulas
• Find expanded coverage of discounting, depreciation, and other financial formulas
• Perform magic with powerful array formulas
• Use your formulas to enhance charts and pivot tables
• Debug formulas and take advantage of Excel's auditing tools
• Develop custom worksheet functions with VBA

Bonus CD-ROM Includes

• A trial version of the author's award-winning Power Utility Pak 2000
• A demo of the author's Sound-Proof 2000
• Example Excel workbooks from the book

System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements.

See all Editorial Reviews

Product Details

• Paperback: 760 pages
• Publisher: Wiley (August 15, 2001)
• Language: English
• ISBN-10: 076454800X
• ISBN-13: 978-0764548000
• Product Dimensions: 9.2 x 7.4 x 1.9 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars See all reviews (18 customer reviews)
• Amazon.com Sales Rank: #255,544 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

45 of 46 people found the following review helpful:

5.0 out of 5 stars A Great Book!, October 14, 2001

By	"[e-mail]" (Kansas City, MO USA) - See all my reviews

When Walkenbach published the first version of this title, I read it cover to cover in a week, impressed with the scope and depth therein. Now, in the 2002 version, he has taken reader feedback and enhanced several chapters, along with making the layout even easier to read. He not only explains formulas in a clear and concise way, but with the book comes a CD that gives you the .PDF version for my laptop. Also, the author's website also provides a whole other world of Excel knowledge and links.

Sprinkled liberally throughout the book are tips, tricks, warnings for advanced techniques. And Walkenbach is not afraid to criticize Microsoft for not making the software's statistical features more robust and its worksheet size larger. Take note Microsoft.

In all, Walkenbach has the rare ability to take complex things and explain them simply. As a result, I bought two copies of this title for my office staff to read and reference, too.

39 of 41 people found the following review helpful:

5.0 out of 5 stars Comprehensive but still user-friendly, November 27, 2002

By	Walter Reade (Appleton, WI United States) - See all my reviews

If you were to have only one Excel book in your library, this would be it! I have been using Excel for years, and have learned more from this book that anywhere else. Walkenbach takes the reader from the basics of using formulas all to way to some ultra-advanced formula usage. Most likely, if Excel can do it with a formula, this book will teach show you how. This is a *must have* book for anyone who uses Excel on a regular basis.

For those who want to become a serious Excel power user, I recommend "Excel 2002 Power Programming with VBA" by the same author. While this book contains some overlapping material, it quickly moves on to teach you how to do some pretty exciting stuff.

29 of 30 people found the following review helpful:

4.0 out of 5 stars Won 8-figure international deal with this book!, August 20, 2002

By A Customer

Practical application in minutes! Finally after trying 3 other..."Excel" books I purchased this one, skimmed it and found a ton of useful formulas; grabbed a few and sharpened up a new, international, project proposal to our customer. The book makes it simple to find what you need rapidly. The CDROM includes a PDF copy of the book so you can "take it with you" on your laptop without lugging the text around the globe. Very specific examples; a multitude of professional applications. Recommended for anyone like myself who strives to "work smarter, not harder". I suspected I could do better, and was pleasantly surprised that MSEXCEL2002 had so much more functionality to offer me RIGHT NOW without attending any class or turning myself into a Programmer/Developer. It's surprisingly readable, well organized and applicable in minutes. I hate working with numbers, and yet - this text turned it into a creative process that literally pays off AND I am proud of my work!