Excel Formulas and Functions For Dummies^®

by Ken Bluttman; Peter G. Aitken (Chapel Hill, NC, PGA Consulting)

• ISBN13: 9780764596476
• ISBN10: 0764596470
• Format: eBook
• Copyright: 2005-07-01
• Publisher: For Dummies

Summary

Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions Shows 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 more Gives explanations and examples of real-world situations Provides an abbreviated discussion of an additional 200 functions Excel 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

Table of Contents

Introduction.

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.