categorías corporativa
Libro Electrónico de ámbito Profesional

Excel 365 Advanced Options

76
Idioma:  English
In this ebook you get acquainted with various advanced and useful options and techniques in Excel 365 that can be helpful in designing and using your calculation models.
La suscripción Profesional Plus es gratuita durante los primeros 30 días, posteriormente %cuesta%/mo
Accede a este libro en nuestro eReader. No hay publicidad dentro del libro.
Descripción
Contenido

Excel 365 has numerous tools to help you designing your models, checking your formulas, finding solutions or creating scenarios, and the like. You’ll also learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, some advanced topics are discussed such as (external) references, security, and the (saving in a certain) format of your workbooks.

About the author

Peter Scharpff originates from the scientific computer-linguistic field focussing on the interaction between man and machine, especially on speech and language engineering. After that he started to develop training material for office automation. In the last few decades he has also created many publications on more general topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, and the like.

  • About the author
  1. Introduction
    1. Structure
    2. Notation
    3. Software
  2. Checking formulas
    1. Introduction
    2. Simple numbers
    3. Auditing
    4. Evaluating
    5. Exercise
  3. Filling cells
    1. Introduction
    2. Series
    3. Lists
    4. Exercise
  4. Sheets and windows
    1. Introduction
    2. Worksheets
    3. Windows
  5. References
    1. Introduction
    2. Copying and linking
    3. External link
    4. Hyperlinks
    5. Exercise
  6. Protection
    1. Introduction
    2. Protecting a Workbook
    3. Protecting a Sheet
  7. Comments
    1. Introduction
    2. Shapes
    3. Notes and Comments
  8. Planning
    1. Introduction
    2. Schedule
    3. Conditional Formatting
    4. Exercise
  9. Solutions
    1. Introduction
    2. Goal Seeking
    3. Solver
  10. Error Checking
    1. Introduction
    2. IntelliSense
    3. Actions
  11. Saving workbooks
    1. Introduction
    2. Location
    3. File type
  • Appendix
Sobre el Autor
Dr.

Dr. Peter J. Scharpff RI