Excel: Scenario Analysis and What-If Analysis
Duration20'
No. of mini-lessons7
ResourcesTranscript
Duration 20'
No. of mini-lessons 7
Resources Transcript
Course overview
When working with data, your employees might often wonder how different values could impact the outcome. Well, with Excel’s What-If Analysis tools, like Scenarios, they can find out. What-If Analysis has a wide range of uses and is handy to have as an option, even if they just want to play around with some numbers. They can see what effect it has without messing up their data.
This course will show them different ways to perform a What-If Analysis. It’ll focus on Scenarios, Goal Seek, Data Tables, and preparing forecasts. Each video will cover a specific type of analysis, so they can choose exactly what they want to learn, at a pace that suits them.
What's covered
Using Scenario Manager and the Goal-Seek function
Working with one-variable and two-variable Data Tables
The Solver Add-In
Forecast sheets
Monte Carlo simulation (RAND and RANDBETWEEN functions)
Why your teams need this course
It can be helpful to see what effect changing certain values can have on the data, even just to satisfy a curiosity. This course is ideal for anyone who’s familiar with Excel and wants to carry out analyses to explore their data further. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
