ulliTargets beginning to intermediate Excel users seeking real-world examples of how they can use Excel’s powerful built-in functionsliShows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and moreliGives explanations and examples of real-world situationsliProvides an abbreviated discussion of an additional 200 functionsliExcel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well/ulIntroduction.pbPart I: Getting Started with Excel Formulas and Functions./bpChapter 1: Understanding Fundamentals, Formulas, and Functions.pChapter 2: Saving Time with the Insert Function Dialog Box.pChapter 3: Understanding Array Formulas and Functions.pChapter 4: Correcting Formulas.pbPart II: Evaluating Loans and Investments./bpChapter 5: Calculating Loan Payments and Interest Rates.pChapter 6: Performing Advanced Financial Calculations.pbPart III: Working with Numbers./bpChapter 7: Using Math Functions to Figure Basic Math Answers.pChapter 8: Getting More Advanced with Math.pChapter 9: Using Descriptive Statistical Functions.pChapter 10: Using Significance Tests.pChapter 11: Using Prediction and Probability Functions.pbPart IV: Working with Data./bpChapter 12: Working with Date Functions.pChapter 13: Keeping Track with Time Functions.pChapter 14: Using Lookup, Logical, and Reference Functions.pChapter 15: Working with Information Functions.pChapter 16: Working with Text Functions.pChapter 17: Summarizing Data with Database Functions.pbPart V: The Part of Tens./bpChapter 18: Ten + One Great Tips for Working with Formulas.pChapter 19: Top Ten Functions You Must Know to Be an Excel Guru.pChapter 20: Ten Cool Things to Do with the Analysi@)úáG®{ ¾Û€