Categories Pricing Corporate
Professional eBook

Excel 2021: Special Models

Workbook 5

73
Language:  English
In this ebook, you'll encounter various aspects of (advanced) models and design techniques to create professional and easily (re) usable spreadsheets with Excel 2021.
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

In a spreadsheet program it is all about designing and building an appropriate calculation model: what is the purpose of it, what should it calculate, what do we want to find out, analyse or even predict, and so on? In this workbook we discuss various (advanced) model designs in Excel 2021, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.

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. Model design
    1. Introduction
    2. Purpose
    3. Directions
    4. 3-D
    5. Getting Started
  3. Outline
    1. Introduction
    2. Large model
    3. AutoOutline
    4. Go To Special
    5. Grouping
  4. Consolidation
    1. Introduction
    2. Merging
    3. Source data
    4. Exercise
  5. Data tables
    1. Introduction
    2. Database
    3. Actions
    4. Data form
    5. Case study
  6. Looking up data
    1. Introduction
    2. Vertical lookup
    3. Nothing found
    4. Horizontal Lookup
  7. Forecasting
    1. Introduction
    2. Tables with variables
    3. Risks
    4. Exercise
  8. Pivot tables
    1. Introduction
    2. Data table
    3. Calculating
    4. PivotChart
    5. Exercise
  • That’s it
  • Appendix
About the Author
dr

dr Peter J. Scharpff RI