Contents at a Glance
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . xv
Part I Basic Information
Chapter 1 Excel in a Nutshell . . . . . . . . . . . . . . . . . . . . . . . . . 3
Chapter 2 Basic Facts about Formulas . . . . . . . . . . . . . . . . . . 29
Chapter 3 Working with Names . . . . . . . . . . . . . . . . . . . . . . 55
Part II Using Functions in Your Formulas
Chapter 4 Introducing Worksheet Functions . . . . . . . . . . . . . 95
Chapter 5 Manipulating Text . . . . . . . . . . . . . . . . . . . . . . . . 111
Chapter 6 Working with Dates and Times . . . . . . . . . . . . . . 135
Chapter 7 Counting and Summing Techniques . . . . . . . . . . . 175
Chapter 8 Using Lookup Functions . . . . . . . . . . . . . . . . . . . 207
Chapter 9 Databases and Lists . . . . . . . . . . . . . . . . . . . . . . . 233
Chapter 10 Miscellaneous Calculations . . . . . . . . . . . . . . . . . 267
Part III Financial Formulas
Chapter 11 Introducing Financial Formulas . . . . . . . . . . . . . . 293
Chapter 12 Discounting and Depreciation Financial
Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 333
Chapter 13 Advanced Uses of Financial Functions
and Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 357
Part IV Array Formulas
Chapter 14 Introducing Arrays . . . . . . . . . . . . . . . . . . . . . . . 383
Chapter 15 Performing Magic with Array Formulas . . . . . . . . 405
Part V Miscellaneous Formula Techniques
Chapter 16 Intentional Circular References . . . . . . . . . . . . . . 433
Chapter 17 Charting Techniques . . . . . . . . . . . . . . . . . . . . . . 449
Chapter 18 Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 497

．．．