Log på Gratis prøveperiode

Follow us

Velkommen til Bookboon

For at levere vores tjenester er vi afhængige af en række vigtige cookies for at få adgang til vores funktioner.

Se Cookies Detaljer
Kategorier Virksomhedsløsninger
Professional eBook

Excel 2021: Advanced Options

Workbook 4

by Dr. Peter J. Scharpff RI
69
Language:  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.
Professionel Plus abonnementet gratis de første 30 dage, derefter $6.99 /måned
Læs denne bog i vores online eReader. Ingen reklamer
Beskrivelse
Indhold
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.

Skriv en anmeldelse
About the Author
Dr.

Dr. Peter J. Scharpff RI

Discover Author
Related Content