|
Excel 2003 Formulas
|
List Price:
$44.99
Bugarin.info Price:
$29.69
Your Savings: $ 15.30 ( 34% )
Subject To Change Without Notice
Availability: Usually ships in 24 hours
Manufacturer: For Dummies
|
Average Customer Rating:  
|
|
Binding: Paperback
Dewey Decimal Number: 005.54
EAN: 9780764540738
ISBN: 0764540734
Label: For Dummies
Manufacturer: For Dummies
Number Of Items: 1
Number Of Pages: 864
Publication Date: 2003-10-17
Publisher: For Dummies
Studio: For Dummies
|
|
|
|
|
|
|
|
|
Editorial Reviews:
|
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
|
|
|
Spotlight customer reviews:
|
Customer Rating: 
Summary: Excellent Excel Book for Intermediate to Expert Users
Comment: 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.
Customer Rating:
Summary: Very useful for any level of knowledge
Comment: I am not a novice in excel but I learned a lot. Easy to read an to follow.
It was exactly what I expected.
Customer Rating:
Summary: Excell Formulas
Comment: 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.
Customer Rating:
Summary: Exactly what I needed
Comment: 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.
Customer Rating:
Summary: Excellent book, but there's a better choice
Comment: 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".
|
|
|
|
|
|
|
|
