الفئات الشركات
كتب Professional الإلكترونية

Excel for Microsoft 365: Special Models

Workbook 5

73
اللغة:  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 for Microsoft 365.
اشتراك Professional Plus ‏‎‎مجاني‎‎ لأول ‎30‎ ‏يوم‎‎ ثم ‏ $6.99 شهريًا بعد ذلك
الوصول إلى هذا العنوان على منصة bookboon
الوصف
المحتوى
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 for Microsoft 365, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.

About the Author

Peter Scharpff is oorspronkelijk afkomstig uit de computer-linguïstische hoek. Zijn wetenschappelijke focus lag op de interactie tussen mens en machine, vooral op de spraak- en taaltechnische kant daarvan. Behalve het ontwikkelen van materiaal voor trainingsdoeleinden op het gebied van kantoorautomatisering, heeft hij ook vele publicaties op zijn naam staan over algemenere onderwerpen als digitale veiligheid, privacy, hardware, programmeren, webdesign, telewerken, sociale netwerken, en dergelijke.

---

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. 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

Use Excel to create prediction models and analyze potential future outcomes. Develop skills in utilizing data tables for managing information and calculating projections. Experiment with PivotTables and PivotCharts to interpret and visualize data. Understand the application of VBA for customizing Excel functionalities and automating tasks.

نبذة عن المؤلف
Dr.

Dr. Peter J. Scharpff RI