Contents at a Glance

• Introduction ………………………………………………..1
• Part 1: Getting Started with Excel Formulas
• and Functions ………………………………………………5
• CHAPTER 1: Tapping Into Formula and Function Fundamentals ………………7
• CHAPTER 2: Saving Time with Function Tools ……………………………39
• CHAPTER 3: Saying “Array!” for Formulas and Functions ……………………55
• CHAPTER 4: Fixing Formula Boo-Boos ………………………………….65
• Part 2: Doing the Math …………………………………….83
• CHAPTER 5: CalculatingLoanPaymentsandInterestRates …………………85
• CHAPTER 6: Appreciating What You’ll Get, Depreciating What You’ve Got ……..105
• CHAPTER 7: Using Basic Math Functions ………………………………121
• CHAPTER 8: Advancing Your Math ……………………………………139
• Part 3: Solving with Statistics …………………………….161
• CHAPTER 9: ThrowingStatisticsaCurve ……………………………….163
• CHAPTER 10:UsingSignicanceTests ………………………………….203
• CHAPTER 11:RollingtheDiceonPredictionsandProbability ………………..213
• Part 4: Dancing with Data ………………………………..231
• CHAPTER 12: Dressing Up for Date Functions ……………………………233
• CHAPTER 13: Keeping Well-Timed Functions …………………………….251
• CHAPTER 14:UsingLookup,Logical,andReferenceFunctions ………………261
• CHAPTER 15: Digging Up the Facts …………………………………….297
• CHAPTER 16:WritingHomeaboutTextFunctions ………………………..311
• CHAPTER 17:PlayingRecordswithDatabaseFunctions ……………………337
• Part 5: The Part of Tens …………………………………..353
• CHAPTER 18: Ten Tips for Working with Formulas ………………………..355
• CHAPTER 19: Ten Ways to Get Fancy with Excel ………………………….369
• CHAPTER 20:TenReallyCoolFunctions ………………………………..375
• Index ………………………………………………………383
• Excel® Formulas & Functions