John Walkenbach – Excel 2002 Formulas (Includes New Financial Formulas)

FROM THE BACK COVER

This one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet, it covers the new features of excel 2002 and expanded with two all-new chapters on financial formulas. John Walkenbach shares proven solutions for typical (and not-so-typical) excel challenges with clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples. This in-depth guide will help you get the most out of your spreadsheets, from working with dates to creating array formulas. There is a road map to high- performance excel formulas. You can get a concise overview of the many features of excel. Master basic formula facts include absolute vs. relative references, operators, error values, and more. Get tips on how to use the functions in excel in your formulas. Find expanded coverage of financial formulas. Powerful array formulas are used to perform magic. Formulas can be used to enhance charts and pivot tables. Take advantage of the auditing tools in excel. VBA can be used to develop custom functions. There is a bonus CD-ROM included. The Power Utility pak 2000 is a trial version. There is a demo of Sound-Proof 2000. The example is from the book. There are requirements for a PC with Windows 98 or greater. The complete system requirements can be found in the About the CD appendix.