* Targets beginning to intermediate Excel users seekingreal-world examples of how they can use Excel's powerful built-infunctions* Shows readers how to use Excel functions in formulas to helpthem decide between buying and leasing a car, calculate mortgagecosts, compute grades, evaluate investment performance, figurecollege expenses, and more* Gives explanations and examples of real-world situations* Provides an abbreviated discussion of an additional 200functions* Excel commands nearly 90 percent of the market for spreadsheetapplications; although this book is written for Excel 2003, thefunctions described are in earlier versions as well

Introduction.Part I: Getting Started with Excel Formulas andFunctions.Chapter 1: Understanding Fundamentals, Formulas, andFunctions.Chapter 2: Saving Time with the Insert Function Dialog Box.Chapter 3: Understanding Array Formulas and Functions.Chapter 4: Correcting Formulas.Part II: Evaluating Loans and Investments.Chapter 5: Calculating Loan Payments and Interest Rates.Chapter 6: Performing Advanced Financial Calculations.Part III: Working with Numbers.Chapter 7: Using Math Functions to Figure Basic MathAnswers.Chapter 8: Getting More Advanced with Math.Chapter 9: Using Descriptive Statistical Functions.Chapter 10: Using Significance Tests.Chapter 11: Using Prediction and Probability Functions.Part IV: Working with Data.Chapter 12: Working with Date Functions.Chapter 13: Keeping Track with Time Functions.Chapter 14: Using Lookup, Logical, and Reference Functions.Chapter 15: Working with Information Functions.Chapter 16: Working with Text Functions.Chapter 17: Summarizing Data with Database Functions.Part V: The Part of Tens.Chapter 18: Ten + One Great Tips for Working with Formulas.Chapter 19: Top Ten Functions You Must Know to Be an ExcelGuru.Chapter 20: Ten Cool Things to Do with the Analysis ToolPakAdd-In.Index.