Record Display for the EPA National Library Catalog
RECORD NUMBER: 1 OF 1
| OLS Field Name | OLS Field Data | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Main Title | Formulas and functions : Microsoft Excel 2010 / | |||||||||||
| Author | McFedries, Paul. | |||||||||||
| Publisher | Que, | |||||||||||
| Year Published | 2010 | |||||||||||
| OCLC Number | 471787423 | |||||||||||
| ISBN | 9780789743060; 078974306X | |||||||||||
| Subjects | Business--Computer programs. ; Electronic spreadsheets. ; Manuels. ; Bureautique. ; Logiciels. ; Excel 2010 ; Tabellenkalkulation | |||||||||||
| Holdings |
|
|||||||||||
| Collation | xvi, 490 pages : illustrations ; 24 cm. | |||||||||||
| Notes | Includes index. |
|||||||||||
| Contents Notes | Mastering Excel Ranges and Formulas -- 1. Getting the Most Out of Ranges -- 2. Using Range Names -- 3. Building Basic Formulas -- 4. Creating Advanced Formulas -- 5. Troubleshooting Formulas -- Part II. Harnessing the Power of Functions -- 6. Using Functions -- 7. Working with Text Functions -- 8. Working with Logical and Information Functions -- 9. Working with Lookup Functions -- 10. Working with Date and Time Functions -- 11. Working with Math Functions -- 12. Working with Statistical Functions -- Part III. Building Business Models -- 13. Analyzing Data with Tables -- 14. Analyzing Data with PivotTables -- 15. Using Excel's Business Modeling Tools -- 16. Using Regression to Track Trends and Make Forecasts -- 17. Solving Complex Problems with Solver -- Part IV. Building Financial Formulas -- 18. Building Loan Formulas -- 19. Building Investment Formulas 20. Building Discount Formulas. |