Excel formulas and functions for dummies /
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 investm...
| Основен автор: | Bluttman, Ken. |
|---|---|
| Други автори: | Aitken, Peter. |
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
Hoboken, N.J. :
Wiley,
℗♭2005.
|
| Серия: |
--For dummies.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=139672 |
| Подобни документи: |
Print version::
Excel formulas and functions for dummies. |
Съдържание:
- 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.