Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.
You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier.
In the ever-popular, non-threatening For Dummies style,Excel Formulas and Functions For Dummies, 2nd Editionmakes Excel's power accessible to you.
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: Doing the Math.
Chapter 5: Calculating Loan Payments and Interest Rates.
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got.
Chapter 7: Using Basic Math Functions.
Chapter 8: Advancing Your Math.
Part III: Solving with Statistics.
Chapter 9: Throwing Statistics a Curve.
Chapter 10: Using Signifi cance Tests.
Chapter 11: Rolling the Dice on Predictions and Probability.
Part IV: Working with Data.
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.
Chapter 16: Writing Home about Text Functions.
Chapter 17: Playing Records with Database Functions.
Part V: The Part of Tens.
Chapter 18: Ten Tips for Working with Formulas.
Chapter 19: Ten Functions You Really Should Know.
Chapter 20: Some Really Cool Functions.
Index.
Peter Aitkenhas written about computers and programming for over 10 years and has written more than 35 books, includingExcel Programming Weekend Crash Course.