Log in

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories About Us
Professional eBook

Excel 2024: Special Models

Workbook 5

by Dr. Peter J. Scharpff RI
74
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 2024.
Professional Plus subscription free for the first 30 days, then $6.99/mo
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 2024, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.

  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
Write a review
About the Author
Dr.

Dr. Peter J. Scharpff RI

Related Content