Product Description

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.

Product Details

• Amazon Sales Rank: #243828 in Books
• Published on: 1999-11-05
• Original language: English
• Number of items: 1
• Binding: Paperback
• 792 pages

About the Author
John Walkenbach is one of the country's leading authorities on spreadsheet software. He's principal of Jwalk and 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 Excel 97 Bible, Excel 97 For Windows® For Dummies® Quick Reference, and Excel 97 Programming For Windows® For Dummies®. jwalk.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.

Customer Reviews

You Must Have This Book.
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.

A Must Have Reference!!!!
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.

Amazing - BUY IT !
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.