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 CourseDuration
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