Part I: Getting Started with Excel Formulas and Functions.

Chapter 1: Understanding Fundamentals, Formulas, and Functions.

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

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

Chapter 20: Ten Cool Things to Do with the Analysis ToolPak Add-In.

Index.