Cargando…
Excel 2013 Formulas.
Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as ""Mr. Spreadsheet, "" is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 201...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Hoboken :
Wiley,
2013.
|
| Colección: | Mr. Spreadsheet's bookshelf.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover; Table of Contents; Title Page; Introduction; Part I: Basic Information; Chapter 1: Excel in a Nutshell; Chapter 2: Basic Facts about Formulas; Chapter 3: Working with Names; Part II: Using Functions in Your Formulas; Chapter 4: Introducing Worksheet Functions; Chapter 5: Manipulating Text; Chapter 6: Working with Dates and Times; Chapter 7: Counting and Summing Techniques; Chapter 8: Using Lookup Functions; Chapter 9: Working with Tables and Lists; Chapter 10: Miscellaneous Calculations; Part III: Financial Formulas; Chapter 11: Borrowing and Investing Formulas.
- Chapter 12: Discounting and Depreciation FormulasChapter 13: Financial Schedules; Part IV: Array Formulas; Chapter 14: Introducing Arrays; Chapter 15: Performing Magic with Array Formulas; Part V: Miscellaneous Formula Techniques; Chapter 16: Importing and Cleaning Data; Chapter 17: Charting Techniques; Chapter 18: Pivot Tables; Chapter 19: Conditional Formatting; Chapter 20: Using Data Validation; Chapter 21: Creating Megaformulas; Chapter 22: Tools and Methods for Debugging Formulas; Part VI: Developing Custom Worksheet Functions; Chapter 23: Introducing VBA.
- Chapter 24: Function Procedure BasicsChapter 25: VBA Programming Concepts; Chapter 26: VBA Custom Function Examples; Part VII: Appendixes; Appendix 1: Excel Function Reference; Appendix 2: Using Custom Number Formats.