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

John Walkenbach (Author)

Book Description

ISBN-10: 076454800X | ISBN-13: 978-0764548000 | Publication Date: August 15, 2001

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.

Editorial Reviews

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. www.mandtbooks.com

About the Author

John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.

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.2 x 1.8 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 Best Sellers Rank: #676,166 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the foremost authority on Excel. His fifty-plus books include Excel 2010 Power Programming with VBA, Excel 2010 Formulas, and the bestselling Excel 2010 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pak.

Customer Reviews

Most Helpful Customer Reviews

43 of 44 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

This review is from: Microsoft Excel 2002 Formulas (With CD-ROM) (Paperback)

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

This review is from: Microsoft Excel 2002 Formulas (With CD-ROM) (Paperback)

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

This review is from: Microsoft Excel 2002 Formulas (With CD-ROM) (Paperback)

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!