Connexion Testez gratuitement

Follow us

Bienvenue sur Bookboon

Afin de vous proposer nos services, nous nous reposons sur des cookies. Ceux-ci sont essentiels pour accéder à nos fonctionnalités.

Lire les détails relatifs aux cookies
Catégories Fixation des prix Corporatif
Livre électronique professionnel

Excel 2021: Special Models

Workbook 5

par Dr. Peter J. Scharpff RI
73
Langue:  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.
Abonnement Pro Plus gratuit pour les 30 premiers jours, puis $6.99/mois
Lisez ce livre avec notre eReader, sans pubs
Description
Contenu
book.tabs.learning objectives

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

Learn how to use essential tools in Excel for model design and data analysis. Design models to calculate growth forecasts with different variables. Create data tables to manage information and perform lookups. Implement pivot tables to summarize and analyze large data sets.

Ecrire un commentaire
A propos de l'auteur
Dr.

Dr. Peter J. Scharpff RI

Découvrir l'auteur
Contenu associé