Microsoft Excel 2000 Formulas [With CDROM]

by John Walkenbach

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... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0764546090
• ISBN13: 9780764546099
• Release Date: November 1999
• Publisher: Wiley Publishing
• Length: 792 Pages
• Weight: 2.70 lbs.
• Dimensions: 1.9" x 7.0" x 9.0"

Customer Reviews

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.

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.

This is THE ONE !!

I am usually the guy who amazes his co-workers with Excel capabilities, and have used Excel from it's inception. The formulas books were always a good help... but THIS book simply amazed me! I didn't get past SECTION 1 without learning half a dozen things I could use immediately! I'm already "scaring" my managers with the things I've learned. Talk about impact! Well written, easy to understand examples, and thorough. If you want to stay on a simple level with Excel (or just a general overview) go for a less expensive book. BUT IF YOU WANT DETAIL (plenty of it here!) and "comprehensive comprehension" - this is what you're looking for.

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.

You May Think You Know Excell . . . But

If you don't have this book by Walkenbach you are at a serious disadvantage when building Excel spreadsheets. That's the long and short of it. This book is an invaluable reference in building business models. I've been developing complicated spreadsheets for years and years, but this book shows tips and tricks I never dreamed of before. Well worth the money. From now on, if Walkenbach's name is on the cover, I shell out the money to get it. Absolutely outstanding. Never read anything better