×
![]( "Buchcover ISBN 9781118053331")
Excel 2003 Formulas
von John WalkenbachEverything you need to know about
* Mastering operators, error values, naming techniques, andabsolute versus relative references
* Debugging formulas and using the auditing tools
* Importing and exporting XML files and mapping the data tospecific 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 aspreadsheet to life like John Walkenbach. In this detailedreference guide, he delves deeply into understanding, creating, andapplying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examinesfinancial formulas, explores the many options made possible witharray formulas, teaches you to develop custom worksheet functionswith VBA, and much more. Once again, „Mr. Spreadsheet“ will astoundyou 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
* Mastering operators, error values, naming techniques, andabsolute versus relative references
* Debugging formulas and using the auditing tools
* Importing and exporting XML files and mapping the data tospecific 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 aspreadsheet to life like John Walkenbach. In this detailedreference guide, he delves deeply into understanding, creating, andapplying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examinesfinancial formulas, explores the many options made possible witharray formulas, teaches you to develop custom worksheet functionswith VBA, and much more. Once again, „Mr. Spreadsheet“ will astoundyou 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
