Rating: 
Summary: Microsoft Excel 2000 Formulas
Review: This is the only spreadsheet book I've ever purchased. I enjoyed the sections on pivot tables, solver, and especially the creation of surface charts. Having breezed through the book twice I feel fairly confident about creating some truly great spreadsheets.
Rating: 
Summary: The Bulb is getting brighter!!
Review: Walkenbach's book on formulas is terrific for the novice. I've been using it to explain the syntax of formulas that I have been working with over the past several months. His explanation of formulas, and how Excel works, has really enhanced my understanding of Excel and how to use its true power.
Rating:
Summary: Excel-ent!!!
Review: We use Excel extensively at work, but I always found using formulas in Excel to be much more difficult than, say, Quattro Pro or Lotus 1-2-3. Well, with this book in hand, I got farther in an hour than I have in months of haphazardly using Excel and the (hmm) help files. This book is NOT just about formulae--there is excellent background on Excel and a good introduction to some of the most central features, such as multiple worksheets and data entry tips. Excel is a powerful program and though you can set up a simple spreadsheet with little or no training, using the deeper functions becomes a bit complicated. This book helps you dip into more of the things Excel can do and which frankly are not well explained by the manual or the help files. We do a lot of charts and forecasts. I found the chapter on charting helpful. I also found a bunch of tips and tricks on naming cells that I hadn't used before (for example, I've named cells for charts but never for variables in a formula.) Having examples of formulae also saves a lot of time. Maybe the formula is not exactly one you need, but having one to start from sure helps. This book is a fantastic tutorial and really expanded my knowledge of Excel quickly. What's interesting about this book is that it also includes a history of Excel, starting with VisiCalc. I used VisiCalc when it first came out--and spreadsheets revolutionized what you could do on the earliest of PC's. The history section is wonderful reading --a nice thing to see in what could have been a dry subject. I think this could be classified as "the missing manual." A must for anyone doing forecasting, math functions or anything more than basic Excel work.
Rating:
Summary: This is THE BOOK
Review: You will be amazed at how many things you can do with Excel even without any VBA programming. The chapter on array formulas is definitely what change my style of writting formulas, especially those for database functionality. This book is a MUST for any Excel user, period.
Rating:
Summary: This is THE BOOK
Review: You will be amazed at how many things you can do with Excel even without any VBA programming. The chapter on array formulas is definitely what change my style of writting formulas, especially those for database functionality. This book is a MUST for any Excel user, period.
| 
