Excel 2000 Formulas [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0764546090 | ISBN-13: 978-0764546099 | Publication Date: November 5, 1999

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

Editorial Reviews

About the Author

John Walkenbach is one of the country's leading authorities on spreadsheet software. He's principal of JWalk & Associates Inc., a Southern California-based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the Power Utility Pak add-in for Excel. John has written more than 250 articles and reviews for publications such as PC World, InfoWorld, Windows, and PC/Computing. In addition, he's authored more than 20 other spreadsheet books, including Microsoft Excel 2000 Bible, Excel 2000 For Windows For Dummies Quick Reference, and Excel 2000 Programming For Dummies. He also maintains the Spreadsheet Page on the World Wide Web (j-walk.com). When he's not banging away on his computer keyboard, he's probably banging away on one of his guitars, trying to cop a few blues licks from Freddie King.

Product Details

• Paperback: 792 pages
• Publisher: Wiley (November 5, 1999)
• Language: English
• ISBN-10: 0764546090
• ISBN-13: 978-0764546099
• Product Dimensions: 9 x 7 x 1.9 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (46 customer reviews)
• Amazon Best Sellers Rank: #848,048 in Books (See Top 100 in Books)
  • #32 in Books > Computers & Technology > Microsoft > Spreadsheets

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

105 of 109 people found the following review helpful:

5.0 out of 5 stars You Must Have This Book., September 18, 2001

By 

Don Drake (Dallas, TX, USA) - See all my reviews

This review is from: Excel 2000 Formulas (Paperback)

If you only buy one book on Excel, this should be the one. If you are a low intermediate user (i.e. not brand new to it, but with a passing familiarity) up through seasoned Excel veteran, this book is a help. There are many hidden secrets in Excel. Do you know how to use Array formulas? Create Custom conditional formatting? Save time with Auto-functions? That Circular References can be a good thing? How to give cells names, then use names instead of cell references in your equations so they are easier to edit / understand (I.E. =(Cost of Goods Sold / Sales) vs. =(A1/C3)? How to use VBA to create the exact function you need? This book has it all, plus all the basics and hidden shortcuts (some not even published) I.E. Using CTRL+Shift+F9 to force recalculation.
This book is extremely lucid and easy to understand. Every piece of information is supported by examples. I am a financial analyst and extremely experienced with Excel, yet this book is still helpful. It is almost a one-stop shop, seemingly lacking little. I also have an MBA. MBA's, buy this book BEFORE you by the MBA's Guide to Excel. I did it the other way around, and knowing what I know now, would not have purchased the Guide. In my opinion, anyone considering an Excel guide purchase, should purchase Excel 2000 Formulas first. It is much more than just a list of formulas. It is truly an excellent book, will save you time, effort, and frustration, and is an excellent value even at twice the price.

26 of 26 people found the following review helpful:

5.0 out of 5 stars A Must Have Reference!!!!, August 20, 2000

By 

Michael Walsh (Moscow, Pa USA) - See all my reviews

This review is from: Excel 2000 Formulas (Paperback)

Being new to Excel I was constantly stumped on writing formulas for the various applications I was putting together. I can't tell you how many times I was contacting Microsoft Support for assistance. As helpful as they were, I am no longer in need of them since I got this book. Forget the various "how to use" books if it's help with formula writting that you need. I been through several and none come close to this one. Cover to cover (700+ pages)of well explained examples of every type of formula. Most useful software book I've ever had.

29 of 30 people found the following review helpful:

5.0 out of 5 stars Amazing - BUY IT !, September 18, 2001

By 

F. G. Hamer "MadManxMan" (Isle of Man) - See all my reviews
(REAL NAME)   

This review is from: Excel 2000 Formulas (Paperback)

I already had a reputation at work as the Excel Wizard, so I was a little cautious about investing in a 'how-to' book on the subject. I have to say though, that Excel 2000 Formulas is worth every last cent and more. Even skimming through the early chapters, where I doubted I would find anything new, I chanced upon several easy tips I'd not known before.

Excel 2000 Formulas is arranged in a simple-to-reference way and the page layout is excellent, giving easy-on-the-eye icon notes, references and tips. Even so, I quickly found myself grabbing a colored highlighter to pick out the bits that were important to me. The author also has a flowing style of writing so you don't feel you're working through a manual, It's more like a fun day out, with new discoveries on every page.

Particulary interesting and useful was John Walkenbach's section on creating megaformulas. Though I was already familiar with the concept, and have used it to good effect at work, I found Walkenbach's methods even more concise and precise. In no time at all, you're building a relatively simple 229 character formula that does the work of 51 intermediary formulas. Not only is this more efficient and streamlined, it saves space in the workbook, thus making calculation quicker and more effective. Also of great value was the section on debugging formulas.

VBA had always remained something of a mystery to me (excluding elementary macros) until I got stuck into 'Excel 2000'. Now (with a bit of prompting from John Walkenbach) I'm really getting the hang of it, and finding, again, that I can streamline my workbooks and impress my colleagues. I've already bought 'Excel 2000 Power Programming with VBA' by the same author, and look forward to improving my skills in this area.

If ever there was a technical book that deserves more than five stars, this is it. If you need to improve your Excel skills, there's no other book you should consider - Excel 2000 Formulas has it all.