Excel Formulas & Functions For Dummies

Introduction 1Part 1: Getting Started with Formulas and Functions 5Chapter 1: Tapping Into Formula and Function Fundamentals 7Chapter 2: Saving Time with Function Tools 37Chapter 3: Saying "Array!" for Formulas and Functions 55Chapter 4: Fixing Formula Boo-Boos 65Part 2: Doing the Math 83Chapter 5: Calculating Loan Payments and Interest Rates 85Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 103Chapter 7: Using Basic Math Functions 119Chapter 8: Advancing Your Math 137Part 3: Solving with Statistics 159Chapter 9: Throwing Statistics a Curve 161Chapter 10: Using Significance Tests 199Chapter 11: Rolling the Dice on Predictions and Probability 209Part 4: Dancing with Data 227Chapter 12: Dressing Up for Date Functions 229Chapter 13: Keeping Well-Timed Functions 247Chapter 14: Using Lookup, Logical, and Reference Functions 257Chapter 15: Digging Up the Facts 289Chapter 16: Writing Home About Text Functions 303Chapter 17: Playing Records with Database Functions 327Part 5: The Part of Tens 343Chapter 18: Ten Tips for Working with Formulas 345Chapter 19: Ten Functions You Really Should Know 359Chapter 20: Ten Really Cool Functions 367Index 375