Categories Corporate
Professional eBook

Excel for Microsoft 365: Advanced Options

Workbook 4

70
Language:  English
This workbook covers advanced options and techniques in Excel for Microsoft 365 when designing and using your models, such as creating series, comments, schedules, references, and security.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Få åtkomst till boken på vår läsplatta. Ingen reklam i boken.
Description
Content
book.tabs.learning objectives

There are quite a few tools in Excel for Microsoft 365 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 is oorspronkelijk afkomstig uit de computer-linguïstische hoek. Zijn wetenschappelijke focus lag op de interactie tussen mens en machine, vooral op de spraak- en taaltechnische kant daarvan. Behalve het ontwikkelen van materiaal voor trainingsdoeleinden op het gebied van kantoorautomatisering, heeft hij ook vele publicaties op zijn naam staan over algemenere onderwerpen als digitale veiligheid, privacy, hardware, programmeren, webdesign, telewerken, sociale netwerken, en dergelijke.

---

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. 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

Know the capabilities of using references in Excel for linking data across sheets and workbooks. Learn to schedule and plan activities effectively in Excel using various formatting and calculation methods.

About the Author
Dr.

Dr. Peter J. Scharpff RI