Taylor's Library

Normal view MARC view ISBD view

Excel formulas and functions for dummies / by Ken Bluttman and Peter G. Aitken.

By: Bluttman, Ken.
Contributor(s): Aitken , Peter.
Series: --For dummies. Publisher: Hoboken, N.J. : Wiley, c2005Description: xvi, 385 p. : ill. ; 24 cm.ISBN: 0764575562 (pbk.).Subject(s): Microsoft Excel (Computer file) | Electronic spreadsheets | Business -- Data processingDDC classification: 005.54
Contents:
Introduction - Part I: Getting started with excel formulas and functions: 1. Understanding fundamentals, formulas, and functions - 2. Saving time with the insert function dialog box - 3. Understanding array formulas and functions - 4. Correcting formulas -- Part II: Evaluating loans and investments: 5. Calculating loan payments and interest rates - 6. Performing advanced financial calculations -- Part III: Working with numbers: 7. Using math functions to figure basic math answers - 8. Getting more advanced with math - 9. Using descriptive statistical functions - 10. Using significance tests - 11. Using prediction and probability functions -- Part IV: Working with data: 12. Working with date functions - 13. Keeping track with time functions - 14. Using lookup, logical, and reference functions - 15. Working with information functions - 16. Working with text functions - 17. Summarizing data with database functions -- Part V: The part of tens: 18. Ten + one great tips for working with formulas - 19. Top ten functions you must know to be an Excel guru - 20. Ten cool things to do with the Analysis ToolPak add-in - Index.
Item type Current location Shelf location Call number Copy number Status Notes Date due Barcode
Main Collection Taylor's Library-TU

Floor 3, Shelf 1 , Side 1, TierNo 5, BayNo 4

 005.54 BLU (Browse shelf) 1 Available SOCIT,15008,03,GR 5000027578

Includes index.

Introduction - Part I: Getting started with excel formulas and functions: 1. Understanding fundamentals, formulas, and functions - 2. Saving time with the insert function dialog box - 3. Understanding array formulas and functions - 4. Correcting formulas -- Part II: Evaluating loans and investments: 5. Calculating loan payments and interest rates - 6. Performing advanced financial calculations -- Part III: Working with numbers: 7. Using math functions to figure basic math answers - 8. Getting more advanced with math - 9. Using descriptive statistical functions - 10. Using significance tests - 11. Using prediction and probability functions -- Part IV: Working with data: 12. Working with date functions - 13. Keeping track with time functions - 14. Using lookup, logical, and reference functions - 15. Working with information functions - 16. Working with text functions - 17. Summarizing data with database functions -- Part V: The part of tens: 18. Ten + one great tips for working with formulas - 19. Top ten functions you must know to be an Excel guru - 20. Ten cool things to do with the Analysis ToolPak add-in - Index.