Excel 2007 Formulas
By John Walkenbach
Publisher: Wiley
Final Release Date: December 2008
Pages: 864

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

Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $44.99
Formats:  ePub, Mobi, PDF