Excel formulas and functions for dummies - Bluttman, Ken (Wiley, 2005)
Includes index
Understanding fundamentals, formulas, and functions -- Saving time with the insert function dialog box -- Understanding array formulas and functions -- Correcting formulas -- Calculating loan payments and interest rates -- Performing advanced financial calculations -- Using math functions to figure basic math answers -- Getting more advanced with math -- Using descriptive statistical functions -- Using significance tests -- Using prediction and probability functions -- Working with date functions -- Keeping track with time functions -- Using lookup, logical, and reference functions -- Working with information functions -- Working with text functions -- Summarizing data with database functions -- Ten + one great tips for working with formulas -- Top ten functions you must know to be an Excel guru -- Ten cool things to do with the Analysis ToolPak add-in
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 func