Excel Formulas and Functions for Dummies 2nd Edition

Description

Put the power of Excel formulas and functions to work for you!

  
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.
* See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula
* Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
* Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
* Includes essential coverage of an additional 85 functions

  
In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.

CONTENTS:

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 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.