Formulas and functions with Microsoft Office Excel 2007
“If you’ve never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you’re already an expert and you’re moving up to Excel 2007, this book will quickly show you features you’ve only dreamed of until now...” —Thomas ‘Duffbert’ Duff,...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
Que
2007
|
| Edición: | 1st edition |
| Colección: | Business solutions
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627057706719 |
Tabla de Contenidos:
- Introductio
- Mastering Excel ranges and formulas
- Getting the most out of ranges
- Using range names
- Building basic formulas
- Creating advanced formulas
- Troubleshooting formulas
- Harnessing the power of functions
- Understanding functions
- Working with text functions
- Working with logical and information functions
- Working with lookup functions
- Working with date and time functions
- Working with math functions
- Working with statistical functions
- Building business models
- Analyzing data with tables
- Analyzing data with PivotTables
- Using Excel's business-modeling tools
- Using regression to track trends and make forecasts
- Solving complex problems with Solver
- Building financial formulas
- Building loan formulas
- Building investment formulas
- Building discount formulas
- Index.
