Webinar Excel: Simulations in Excel

  • Version: Office 2013/2016
  • Duration: 1 hour


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
  • Structuring the calculation
  • Determining the variables
  • Analysing the solution

Request an offer

Share this course on Facebook, Twitter, LinkedIn or e-mail

Interested in this online training?

We transform your requirements into the perfect solution.