Connexion Testez gratuitement

Follow us

Bienvenue sur Bookboon

Afin de vous proposer nos services, nous nous reposons sur des cookies. Ceux-ci sont essentiels pour accéder à nos fonctionnalités.

Lire les détails relatifs aux cookies
Catégories Corporatif
Livre électronique professionnel

Excel 2021: Advanced Options

Workbook 4

par Dr. Peter J. Scharpff RI
69
Langue:  English
This workbook covers advanced options and techniques in Excel 2021 when designing and using your models, such as creating series, comments, schedules, references, and security.
Abonnement Pro Plus gratuit pour les 30 premiers jours, puis $6.99/mois
Lisez ce livre avec notre eReader, sans pubs
Description
Contenu
book.tabs.learning objectives

There are quite a few tools in Excel 2021 that you can use when designing your models, checking your formulas, coming up with solutions or scenarios, and so on. In this workbook we discuss various options and techniques for the advanced user. You’ll learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, matters such as (external) reference, security, and (saving in a certain) format of your workbooks are discussed.

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 produced many publications on topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, drawing, audio, video and photo editing and the like.

  • About the author
  1. Introduction
    1. Design
    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. References
    1. Introduction
    2. Copying and linking
    3. External link
    4. Hyperlinks
    5. Exercise
  5. Protection
    1. Introduction
    2. Protecting a Workbook
    3. Protecting a Sheet
  6. Comments
    1. Introduction
    2. Shapes
    3. Notes and Comments
  7. Planning
    1. Introduction
    2. Schedule
    3. Conditional Formatting
    4. Exercise
  8. Solutions
    1. Introduction
    2. Goal Seeking
    3. Solver
  9. Error checking
    1. Introduction
    2. IntelliSense
    3. Actions
  10. Saving workbooks
    1. Introduction
    2. Location
    3. File type
  • That’s it
  • Appendix

Understand different methods for planning and scheduling tasks using Excel. Learn to utilize Excel’s What-If Analysis tools like Goal Seek and Solver for solution finding. Become familiar with the error checking features and how to resolve potential errors. Learn how to save Excel workbooks in different locations and file types for compatibility and sharing.

Ecrire un commentaire
A propos de l'auteur
Dr.

Dr. Peter J. Scharpff RI

Découvrir l'auteur
Contenu associé