Excel Formulas and Functions For Dummies

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.