Webinar Excel: Simulations in Excel

  • Course types: Custom webinar
  • 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
  • Structuring the calculation
  • Determining the variables
  • Analysing the solution

Request an offer



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

Requesting a quotation

Would you like to organize this webinar for your employees? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com