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 2003s rights management feature
Working magic with array formulas
Developing custom formulas to produce the results you need
Heres 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 Excels capacity.
CDROM Includes
Trial version of the authors awardwinning Power Utility Pak 5
More than 90 sample workbooks illustrating key formula concepts
Synopsis
* Part of the bestselling Power Pack family of technical guides, this book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools * Helps the reader master basic formula facts, including absolute vs. relative references, operators, error values, naming techniques, and more * Offers practical tips on using Excel's worksheet functions in formulas, using formulas to enhance charts and pivot tables, developing custom worksheet functions with VBA, using powerful array formulas, and debugging * Written by one of the leading authorities on spreadsheet programs who also maintains the popular online Spreadsheet Page * CD--ROM includes more than ninety example workbooks that illustrate key concepts for the book, as well as the author's award--winning Power Utility Pak
See all Product Description