Put the power of Excel formulas and functions to work foryou!Excel is a complex program. Mastering the use of formulas andfunctions lets you use Excel to compute useful day-to-dayinformation, such as calculating the true cost of credit cardpurchases or comparing 15-year and 30-year mortgage costs. This funand friendly book demystifies Excel's built-in functions so you canput them to work.You'll find step-by-step instructions on 150 of Excel's mostuseful functions, how they work within formulas, and how to usethem to make your life easier.* See how to use 150 of Excel's most useful functions, withreal-world examples showing how each function is used within aformula* Learn to calculate the costs of leasing versus buying a car,compute classroom grades, create an amortization table, or evaluateinvestment performance* Fully updated for Excel 2010, but the principles will work withearlier versions of Excel as well* Includes essential coverage of an additional 85 functionsIn the ever-popular, non-threatening For Dummies style, ExcelFormulas and Functions For Dummies, 2nd Edition makes Excel'spower accessible to you.

Introduction.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 WhatYou'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.