Accedi Prova Gratuita

Follow us

Benvenuto su Bookboon

Per fornire i nostri servizi contiamo su una serie di cookie essenziali per accedere alle nostre funzionalità.

Vedere i dettagli dei cookies
Categories Corporate
home.libro.professionale_ebook

Excel 2021: Special Models

Workbook 5

di Dr. Peter J. Scharpff RI
73
Lingua:  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.
Abbonamento Professional Plus gratuito per i primi 30 giorni poi $6.99 /mese
Non ci sono pubblicità nel libro
Descrizione
Contenuto
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.

Scrivi una recensione
home.libro.su_autore
Dr.

Dr. Peter J. Scharpff RI

home.libro.scoprire_autore
home.libro.relativo_contenuto