Everything you need to know aboutMastering operators, error values, naming techniques, and absolute versus relative referencesDebugging formulas and using the auditing toolsImporting and exporting XML files and mapping the data to specific cellsUsing Excel 2003's rights management featureWorking magic with array formulasDeveloping 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 5More than 90 sample workbooks illustrating key formula concepts