Skip to main content

Webinar Excel: Simulations in Excel

Version: Office 365
Duration: 1 hour

Description

What if you don’t have all the required data? In that case simulations in Excel is the answer.

Excel is a powerful spreadsheet application that allows you to calculate an incredible amount of data based on formulas. To do that, you need all the required data and parameters. But what if you don’t have all the data? What if you want to calculate the optimal allocation of resources, based on a number of predefined variables? Or maybe you want to be able to list a set of variables, in order to make a comparison based on different scenarios. In this webinar you will find out how to do that.

Prerequisites

A sound knowledge of Excel is required.

Content

Part 1: The Scenario Manager

  • Concept
  • Structuring the calculation
  • Adding different scenarios
  • Comparing scenarios

Part 2: Goal Seek

  • Concept
  • Structuring the calculation
  • Calculating the missing value

Part 3: Data Tables

  • Concept
  • Structuring the table and the calculation
  • Analysing the results

Part 4: Solver

  • Enabling the solver add-in
  • De berekening opbouwen
  • Determining the variables
  • Analysing the solution
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?