Excel 2000 Formulas | 
 enlarge | Author: John Walkenbach
Publisher: Wiley
Category: Book
List Price: $44.99
Buy New: $12.99
You Save: $32.00 (71%)
New (20) Used (12) from $10.14
Rating:  45 reviews
Sales Rank: 264199
Media: Paperback
Edition: Pap/Cdr
Pages: 792
Number Of Items: 1
Shipping Weight (lbs): 2.5
Dimensions (in): 8.8 x 7 x 1.8
ISBN: 0764546090
Dewey Decimal Number: 005.369
UPC: 785555018594
EAN: 9780764546099
ASIN: 0764546090
Publication Date: November 5, 1999
Availability: Usually ships in 1-2 business days
Condition: Brand New
| |
| Similar Items:
|
| Editorial Reviews:
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.
|
| Customer Reviews: Read 40 more reviews...
 The Best Excel Tool February 15, 2007
K. Huffman
I have worked with and trained Excel (various versions) for over 10 years. I use this book any time I have to write complicated formulas. I recommend it to anyone who is working with Excel, especially formulas. My copy is very dog-eared and I have so many sticky tabs for frequently referenced sections that it looks like a porcupine book.
I will warn you that using this book may cause you to become an Excel-lover if you aren't already!
Excellent reference April 6, 2006
Hoppaguy
1 out of 1 found this review helpful
This book is very good for learning your way around Excel and its formulas. I am fairly comfortable in Excel and still found the book extremely useful. There are many formulas that are explained which I did not know existed that have made me much more efficient within the program.
 An Exctract From the Author's "Excel Bible" March 20, 2006
PM in NY (New York City)
3 out of 3 found this review helpful
The Excel "Formulas" book is extractions from the same author's
"Excel Bible" book. Although it's easier to find information in this version, that convenience is not worth the extra cost for less information. I made the mistake of buying this version, while also having the "Bible", so I basically wasted my money.
 extremely poor excuse for an expository book December 31, 2005
richard gostanian (salem, new hampshire, USA)
4 out of 5 found this review helpful
I do all my serious mathematical work with Mathematica. However since some of my collegues use Excel for simple data presentation and analysis, I've recently started using Excel to be able to converse with my collegues.
Since most of the elmentary things that one would do with Excel are fairly simple, the built-in help capability is quite adaquate as a learning resource. However, as with any product, there are various useful tricks that go beyond the scope of the built-in help feature, which a good book could address. Because the reviews on Walkenbach's book were so uniformly good, I thought I would give it a try to get some deeper insights into Excel. Unfortunately I was quite disappointed.
Indeed the book contains a wealth of useful examples, and for that reason I gave it two stars. The major problem with the book however, is that it does a very poor (and often non-existent) job of explaining why the examples work.
A case in point is the example on page 402 which shows how to graph a function without populating values in a worksheet. There is a receipe in the text for accomplishing the task. However the receipe is so sketchy that I don't believe anyone would be able to produce a graph by just reading the text.
Fortunately there is a working example on the CD that comes with the book. And more fortunately, the example can be easily modified to produce graphs of other functions. This is all very good! However Walkenbach does not explain why the example works. Moreover, he makes no attempt to explain the obscure functions (OFFSET, SUBSTITUTE, EVALUATE) which the example is based on. Thus all the reader is left with is a template for accomplishing a task. If he keeps the template around, he should be OK. But if he's asked to develop the template on his own, from basic principles, he will not be able to do so.
The graphing example is not an isolated case in the book. Time and time again I found myself fustrated with poor explainations throughout the book -- few of which provide an understanding of why things work.
Understanding why things work is extremely important because without an understanding of how something works, it is impossible to devise solutions to situations that one has not encountered before. Cookbooks are useful for producing tasty meals, but one cannot become a real chef without understanding the principles of cooking. Similarly, this book is at best a reasonable cookbook, but a terrible expository work.
Buy this book!! August 17, 2004
G. D. Roche (Massachusetts)
2 out of 4 found this review helpful
I work with Excel morning, noon, and night in both technical and academic environments, and this is the best book that I have ever found on Excel. The writing is clear and concise, and the examples are many and understandable. I learn something new every time I pick up this book, and my bosses think I can work miracles.
|
|
|
