Comentario
Excel master John Walkenbach has shared his expertise in tw o previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array fo rmulas, develop custom worksheet functions with VBA, debug f ormulas, 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 co me to the right place.
It's estimated that only about ten percent of Excel users re ally understand how to get the most out of worksheet formula s. If you're ready to join that elite group, here's your mem bership kit.
CD-ROM INCLUDES: Sample files for tutorials See the CD appendix for details and complete system requirem ents.
Mr. Spreadsheet's Success Techniques Technique # 1 Master operators, error values, and absolute v s. 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 |