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