Excel 2013 Formulas Book

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