Excel: Simulations


Version: Microsoft 365
Duration: 1 hour
Price training (excl. VAT) starting at: Price on demand
Number of people: 1-100p


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.


A sound knowledge of Excel is required.


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

Book this training

Let's start a conversation!

Team Xylos is ready to meet you