Categories Pricing Corporate
Professional eBook

Excel 2019 Advanced Options

74
Language:  English
In this ebook you get acquainted with various advanced and useful options and techniques in Excel 2019 that can be helpful in designing and using your calculation models.
Professional Plus subscription free for the first 30 days, then $8.99/mo
Access this book on our eReader, no adverts inside the book
Description
Content

Excel 2019 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

Scharpff Consultancy is a consulting organization that has been active in the world of automation for decades. Information, training and guidance on the use of personal automation tools are key focuses. One of the specialties is facilitating (and performing) individual training programs for PC-users. The model for this has been conceived in the early 90s from the last century by Scharpff Consultancy in collaboration with various experts. Nowadays, it is used by most training centers and even by mainstream educational institutions. Individual training has proven to be a better method for learning computer skills than the classroom-trainings that are still predominant in the training world.Scharpff Consultancy has a lot of expertise in developing and publishing materials for individual training purposes. This textbook is a product of that specific know-how. It will allow you to obtain the necessary knowledge and practical skills on your computer completely on your own.

  • 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. 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
About the Author
Dr.

Dr. Peter J. Scharpff RI