Microsoft Office Excel 2007 Formulas and Functions For Dummies

Part I: Putting the Fun in Functions.

Chapter 1: Tapping into Formula and Function Fundamentals.

Chapter 2: Saving Time with Function Tools.

Chapter 3: Saying “Array!” for Formulas and Functions.

Chapter 4: Fixing Formula Boo-Boos.

Part II: Counting on Your Money.

Chapter 5: Calculating Loan Payments and Interest Rates.

Chapter 6: Appreciating What You’ll Get, Depreciating What You Got.

Chapter 7: Using Basic Math Functions.

Chapter 8: Advancing Your Math.

Chapter 9: Throwing Statistics a Curve.

Chapter 10: Using Significance Tests.

Part III: Doing the Math.

Chapter 11: Rolling the Dice on Predictions and Probability.

Chapter 12: Dressing Up for Date Functions.

Chapter 13: Keeping Well-Timed Functions.

Chapter 14: Using Lookup, Logical, and Reference Functions.

Chapter 15: Digging Up the Facts.

Part IV: Working with Data.

Chapter 16: Writing Home about Text Functions.

Chapter 17: Playing Records with Database Functions.

Part V: The Part of Tens.

Chapter 18: Ten-Plus Tips for Working with Formulas.

Chapter 19: Ten-Plus Functions You Really Should Know.

Index.