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