Inloggen Gratis proberen

Follow us

Welkome bij Bookboon

Om onze services te kunnen leveren, gebruiken we een reeks essentiële cookies.

Zie cookiegegevens
Categorieën Zakelijk
Professionele eBook

Excel 2021: Advanced Options

Workbook 4

bij Dr. Peter J. Scharpff RI
69
Taal :  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.
Professioneel Plus abonnement gratis voor 30 dagen, daarna $6.99 per maand
Lees dit boek via onze eReader, geen advertenties in het boek
Beschrijving
Inhoud
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.

Schrijf een beoordeling
Over de auteur
Dr.

Dr. Peter J. Scharpff RI

Ontdek de auteur
Gerelateerd materiaal