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
A good knowledge of the basics of Excel is required (file management, edit data, structure of a sheet, formatting, simple functions and formulas).
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.
- Data tables
- With 1 variable
- With 2 variables
- Create a summary
- Goal Seek
- Enable the Solver in Excel
- Using the Solver