Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Up and Running with Excel What-If Analysis.
I wanted to take a few seconds to talk about what you should know before diving into Up and Running with Excel What If analysis. You'll learn everything that you need inside the course. So that means that you really just need basic Excel skills. Those include editing formulas, editing cells and so on. If you want to apply what you've learned to your own business then you should have a very good idea of how your business operates. And most importantly you should not be afraid to use the Save As feature to try different approaches to modeling. Anytime you want to make a significant change to a model always use Save As to save a new version of the file.
That way you don't get rid of the work that you've already done and you can go back to it if your new approach doesn't work out.
- Creating a scenario
- Defining data tables
- Finding a target value with Goal Seek
- Defining constraints and running Solver
- Creating a configurable model
- Manipulating your model
- Running a Monte Carlo simulation