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
![The Ultimate Beginner's Guide to iWork : [3-in-1 Manual] Step-by-Step Instructions for Pages, Numbers, and Keynote to Create Documents, Spreadsheets, and Presentations with Confidence - Donald Unger](https://cdn.kobo.com/book-images/Images/7ca2c003-ad82-4d72-9618-1fe03b08f518/300/300/False/image.jpg)
