Log in

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories About Us
Professional eBook

Excel 365 Advanced Options

by Dr. Peter J. Scharpff RI
76
Language :  English
In this ebook you get acquainted with various advanced and useful options and techniques in Excel 365 that can be helpful in designing and using your calculation models.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Description
Content

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
Write a review
About the Author
Dr.

Dr. Peter J. Scharpff RI

Related Content