Excel® 2010 Formulas

Excel® 2010 Formulas

Author(s): John Walkenbach

Published Online: 1 NOV 2011 01:56PM EST

Print ISBN: 9780470475362

Online ISBN: 9781118257630

DOI: 10.1002/9781118257630

About this Book

Take your Excel formulas to the next level with this updated reference

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.

You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.

  • Demonstrates how to use all the new features of Excel 2010 to maximize your formulas
  • Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more
  • Serves as an indispensable reference no matter your skill level
  • Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak

Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of contents

    1. You have free access to this content
  1. Part I: Basic Information

  2. Part II: Using Functions in Your Formulas

  3. Part III: Financial Formulas

  4. Part IV: Array Formulas

  5. Part V: Miscellaneous Formula Techniques

  6. Part VI: Developing Custom Worksheet Functions

  7. Part VII: Appendixes

    1. You have free access to this content
    2. You have free access to this content
    3. You have free access to this content
    4. You have free access to this content
    1. You have free access to this content
    1. You have free access to this content
    1. You have free access to this content

SEARCH