Excel Formulas and Functions for Dummies (Paperback, 3)

Introduction 1 Part I: Putting the Fun in 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 57 Chapter 4: Fixing Formula Boo-Boos 69 Part II: Doing the Math 87 Chapter 5: Calculating Loan Payments and Interest Rates 89 Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 109 Chapter 7: Using Basic Math Functions 125 Chapter 8: Advancing Your Math 143 Part III: Solving with Statistics 165 Chapter 9: Throwing Statistics a Curve 167 Chapter 10: Using Signifi cance Tests 205 Chapter 11: Rolling the Dice on Predictions and Probability 215 Part IV: Working with Data 233 Chapter 12: Dressing Up for Date Functions 235 Chapter 13: Keeping Well-Timed Functions 255 Chapter 14: Using Lookup, Logical, and Reference Functions 265 Chapter 15: Digging Up the Facts 297 Chapter 16: Writing Home about Text Functions 311 Chapter 17: Playing Records with Database Functions 337 Part V: The Part of Tens 351 Chapter 18: Ten Tips for Working with Formulas 353 Chapter 19: Ten Functions You Really Should Know 365 Chapter 20: Some Really Cool Functions 371 Index 377