Realdolmen Education

Details

Excel "What If" Analysis Tools (VILT - Virtual Instructor Led Training)

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

0.2 day(s)

Prerequisites

A good knowledge of the basics of Excel is required (file management, edit data, structure of a sheet, formatting, simple functions and formulas).

Description

Excel contains 4 different tools to create simulations (Data table and scenarios) or to define the result of formulas (Goal Seek and Solver). This session will teach you how to use the What-If Analysis tools.

Contents

  • Data tables
    • With 1 variable
    • With 2 variables
  • Scenarios
    • Preparation
    • Create
    • Modify
    • Create a summary
  • Goal Seek
  • Solver
    • Enable the Solver in Excel
    • Using the Solver