| Table of Contents |
| Excel 2007 Formulas |
| Introduction |
| Part I - Basic Information |
| Chapter 1 | - | Excel in a Nutshell |
| Chapter 2 | - | Basic Facts about Formulas |
| Chapter 3 | - | Working with Names |
| Part II - Using Functions in Your Formulas |
| Chapter 4 | - | Introducing Worksheet Functions |
| Chapter 5 | - | Manipulating Text |
| Chapter 6 | - | Working with Dates and Times |
| Chapter 7 | - | Counting and Summing Techniques |
| Chapter 8 | - | Using Lookup Functions |
| Chapter 9 | - | Tables and Worksheet Databases |
| Chapter 10 | - | Miscellaneous Calculations |
| Part III - Financial Formulas |
| Chapter 11 | - | Borrowing and Investing Formulas |
| Chapter 12 | - | Discounting and Depreciation Formulas |
| Chapter 13 | - | Financial Schedules |
| Part IV - Array Formulas |
| Chapter 14 | - | Introducing Arrays |
| Chapter 15 | - | Performing Magic with Array Formulas |
| Part V - Miscellaneous Formula Techniques |
| Chapter 16 | - | Intentional Circular References |
| Chapter 17 | - | Charting Techniques |
| Chapter 18 | - | Pivot Tables |
| Chapter 19 | - | Conditional Formatting and Data Validation |
| Chapter 20 | - | Creating Megaformulas |
| Chapter 21 | - | Tools and Methods for Debugging Formulas |
| Part VI - Developing Custom Worksheet Functions |
| Chapter 22 | - | Introducing VBA |
| Chapter 23 | - | Function Procedure Basics |
| Chapter 24 | - | VBA Programming Concepts |
| Chapter 25 | - | VBA Custom Function Examples |
| Part VII - Appendixes |
| Appendix A | - | Excel Function Reference |
| Appendix B | - | Using Custom Number Formats |
| Appendix C | - | Additional Excel Resources |
| Appendix D | - | What's on the CD-ROM |
| Index |
| List of Figures |
| List of Tables |
| List of Sidebars |
| CD Content |