Excel 2010 Formulas

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 "e;Mr. Spreadsheet,"e; 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.

Take your Excel formulas to the next level with this updatedreferenceJohn Walkenbach's name is synonymous with excellence in computerbooks that decipher complex technical topics. Known as "Mr.Spreadsheet," Walkenbach provides you with clear explanations onall the methods you can use to maximize the power of Excel withformulas within the frameworks of all the new features ofExcel 2010.You'll learn how to create financial formulas, maximize thepower of array formulas, develop custom worksheet functions withVBA, debug formulas, and much more. This invaluable reference isfully updated for the new Microsoft Office release and providescomprehensive formulas coverage, delivering more than 800 pages ofExcel tips, tricks, and techniques you won't find anywhereelse.* Demonstrates how to use all the new features of Excel 2010 tomaximize your formulas* Shows how to develop custom worksheet functions with VBA, debugformulas, create financial formulas, and more* Serves as an indispensable reference no matter your skilllevel* Includes a valuable CD-ROM with sample files, templates andworksheets from the book, plus John Walkenbach's award-winningPower Utility PakPrepare to excel with Excel when you have John Walkenbach andExcel 2010 Formulas by your side!Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Introduction 1Part I: Basic InformationChapter 1: Excel in a Nutshell 11Chapter 2: Basic Facts about Formulas 39Chapter 3: Working with Names 65Part II: Using Functions in Your FormulasChapter 4: Introducing Worksheet Functions 103Chapter 5: Manipulating Text 119Chapter 6: Working with Dates and Times 143Chapter 7: Counting and Summing Techniques 181Chapter 8: Using Lookup Functions 213Chapter 9: Tables and Worksheet Databases 235Chapter 10: Miscellaneous Calculations 275Part III: Financial FormulasChapter 11: Borrowing and Investing Formulas 293Chapter 12: Discounting and Depreciation Formulas 317Chapter 13: Financial Schedules 341Part IV: Array FormulasChapter 14: Introducing Arrays 367Chapter 15: Performing Magic with Array Formulas 391Part V: Miscellaneous Formula TechniquesChapter 16: Intentional Circular References 415Chapter 17: Charting Techniques 429Chapter 18: Pivot Tables 473Chapter 19: Conditional Formatting and Data Validation 519Chapter 20: Creating Megaformulas 555Chapter 21: Tools and Methods for Debugging Formulas 573Part VI: Developing Custom Worksheet FunctionsChapter 22: Introducing VBA 599Chapter 23: Function Procedure Basics 613Chapter 24: VBA Programming Concepts 635Chapter 25: VBA Custom Function Examples 669Part VII: AppendixesAppendix A: Excel Function Reference 717Appendix B: Using Custom Number Formats 733Appendix C: Additional Excel Resources 753Appendix D: What's on the CD-ROM? 759Index 769