Excel formulas and functions for dummies [electronic resource]
| Main Authors: | , |
|---|---|
| Corporate Author: | |
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, NJ :
Wiley ,
c2005
|
| Series: | --For dummies
|
| Subjects: | |
| Online Access: | An electronic book accessible through the World Wide Web; click for information |
Table of Contents:
- 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