Create killer formulas—Mr. Spreadsheet shows you how
Excel master John Walkenbach has shared his expertise in twoprevious editions of this bestseller. Now he shows you how tocreate financial formulas, release the power of array formulas,develop custom worksheet functions with VBA, debug formulas, andmore with Excel 2007. If you already know your way around thenewest Excel and want to concentrate on using formulas to extendits capabilities even further, you've come to the right place.
It's estimated that only about ten percent of Excel users reallyunderstand how to get the most out of worksheet formulas. If you'reready to join that elite group, here's your membership kit.
Sample files for tutorials
See the CD appendix for details and complete systemrequirements.
Mr. Spreadsheet's Success Techniques
Technique # 1 Master operators, error values, and absolute vs.relative references
Technique # 2 Find errors and debug formulas
Technique # 3 Use pivot tables to eliminate formulas
Technique # 4 Create single- and multi-cell array formulas
Technique # 5 Build custom functions with VBA