Excel 2007 Formulas

Create killer formulas-Mr. Spreadsheet shows you howExcel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.CD-ROM INCLUDES:Sample files for tutorialsSee the CD appendix for details and complete system requirements.Mr. Spreadsheet's Success TechniquesTechnique # 1 Master operators, error values, and absolute vs. relative referencesTechnique # 2 Find errors and debug formulasTechnique # 3 Use pivot tables to eliminate formulasTechnique # 4 Create single- and multi-cell array formulasTechnique # 5 Build custom functions with VBAJohn Walkenbach is the author of 'Excel 2007 Formulas', published 2007 under ISBN 9780470044025 and ISBN 0470044020.