Contents at a glance
Introduction xxi
CHAPTER 1 Basic spreadsheet modeling 1
CHAPTER 2 Range names 9
CHAPTER 3 Lookup functions 21
CHAPTER 4 The INDEX function 29
CHAPTER 5 The MATCH function 33
CHAPTER 6 Text functions 39
CHAPTER 7 Dates and date functions 55
CHAPTER 8 Evaluating investments by using net present value criteria 63
CHAPTER 9 Internal rate of return 69
CHAPTER 10 More Excel financial functions 75
...