|
Excel 2003 Formulas | 
 enlarge | Author: John Walkenbach
Publisher: For Dummies
Category: Book
List Price: $44.99
Buy New: $16.24
You Save: $28.75 (64%)
New (42) Used (20) from $16.21
Rating:  23 reviews
Sales Rank: 45948
Media: Paperback
Pages: 864
Number Of Items: 1
Shipping Weight (lbs): 2.9
Dimensions (in): 9.4 x 7.4 x 2
ISBN: 0764540734
Dewey Decimal Number: 005.54
UPC: 785555869394
EAN: 9780764540738
ASIN: 0764540734
Publication Date: October 17, 2003
Availability: Usually ships in 1-2 business days
Condition: BRAND NEW; Unmarked w/ unopened CD; FAST, dependable shipping!
| |
| Also Available In:
|
| Accessories:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Everything you need to know about - Mastering operators, error values, naming techniques, and absolute versus relative references
- Debugging formulas and using the auditing tools
- Importing and exporting XML files and mapping the data to specific cells
- Using Excel 2003's rights management feature
- Working magic with array formulas
- Developing custom formulas to produce the results you need
Here's the formula for Excel excellence Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel's capacity. CD-ROM Includes - Trial version of the author's award-winning Power Utility Pak 5
- More than 90 sample workbooks illustrating key formula concepts
|
| Customer Reviews: Read 18 more reviews...
 Excellent Excel Book for Intermediate to Expert Users November 22, 2008
Reenee (Nevada, USA)
I needed this book to write complex Excel formulas for a contract at work. It is EXCELLENT for the most part. It has many, many formulas in it. It's predecessor (Excel Formulas 2000) prompted this purchase becuase it explains the formulas in less than "developer" ease, which most Excel users are not developers and don't know VBA, but need to be able to use Excel and write appropriate formulas and use functions.
The only wish I could have wanted from this book is to add a bit more to the possibilities - like IF(AND(... and IF(OR. It would help immensely if someone would write a book that was "example" oriented to show formulas tied together, like IF(ISERROR(the formula),what to do if it is an error, then what to do if it isn't.) There is a real need to talk about Formula nesting in detail and explain that extensive formula nesting can be done and how. I would have given this book a 5 if these were explained better in the text. I augmented this particular need through Internet research and was able to solve my complex problems.
The book is definitely worth the purchase if you are an Excel specialist or Excel programmer and need a good reference book with well organized and easy-to-understand explanations. I highly recommend it to anyone who uses Excel and needs to create formulas. I don't think it's a book for beginners, but once you have a handle on Excel it's a definite positive addition to your reference library. It saved my new contract.
 Very useful for any level of knowledge July 28, 2008
Gisela Greulich (Cleveland, Ohio)
I am not a novice in excel but I learned a lot. Easy to read an to follow.
It was exactly what I expected.
 Excell Formulas October 30, 2007
S. Poteete (Texas)
0 out of 1 found this review helpful
Decent purchase. Could be a little bit more user friendly. A huge amount of information and can be difficult to find what you are looking for but all in all a good tool.
Exactly what I needed August 14, 2007
H. Montgomery
2 out of 2 found this review helpful
This book is great. It is divided into logical topics that address what I need to do my job on a daily basis. Easy to read, straight to the point. I highly recommend this book.
Excellent book, but there's a better choice July 30, 2007
Michael (Ukraine)
7 out of 7 found this review helpful
I've found that some reviewers say that this book doesn't give enough theory or examples are trivial or you can find that all in the Help. However, I believe that only advanced Excel users might be dissatiafied with "Excel 2003 Formulas". While that's true that it's not overloaded with the advanced theory (which is what professionals look for), it does give the beginners or intermidiate users all they need to know about formulas, and the tips and tricks offered by Walkenbach really help to discover the world of Excel.
However, on the other hand if you're interested not only in formulas, but you're also planning to study the Excel as a whole then I would recommend to get the "Excel 2003 Bible" of this author. The reason is that the "Formulas..." for the most part just copy the "Bible..." which describes usage of the whole Excel and has a lot more information than the "Formulas".
|
|
|
| |
