Introduction 1 PART I: Basic Information Chapter 1: Excel in a Nutshell 9 Chapter 2: Basic Facts about Formulas 33 Chapter 3: Working with Names 61 PART II: Using Functions in Your Formulas Chapter 4: Introducing Worksheet Functions 105 Chapter 5: Manipulating Text 123 Chapter 6: Working with Dates and Times 149 Chapter 7: Counting and Summing Techniques 187 Chapter 8: Using Lookup Functions 221 Chapter 9: Working with Tables and Lists 243 Chapter 10: Miscellaneous Calculations 283 PART III: Financial Formulas Chapter 11: Borrowing and Investing Formulas 307 Chapter 12: Discounting and Depreciation Formulas 327 Chapter 13: Financial Schedules 345 PART IV: Array Formulas Chapter 14: Introducing Arrays 369 Chapter 15: Performing Magic with Array Formulas 395 PART V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data 421 Chapter 17: Charting Techniques 449 Chapter 18: Pivot Tables 493 Chapter 19: Conditional Formatting 545 Chapter 20: Using Data Validation 571 Chapter 21: Creating Megaformulas 583 Chapter 22: Tools and Methods for Debugging Formulas 601 PART VI: Developing Custom Worksheet Functions Chapter 23: Introducing VBA 629 Chapter 24: Function Procedure Basics 643 Chapter 25: VBA Programming Concepts 665 Chapter 26: VBA Custom Function Examples 701 PART VII: Appendixes Appendix A: Excel Function Reference 751 Appendix B: Using Custom Number Formats 769 Index 791.