Book 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 John
Walkenbach, principal of JWalk and Associates Inc., is a leading
authority on spreadsheet software and creator of the award-winning Power
Utility Pak. He has written more than 30 spreadsheet books and over 300
articles and reviews for publications including PC World, InfoWorld, and
Windows, and maintains the popular Spreadsheet Page at www. j-walk.
com/ss.
