Run multiple scenarios in one click
What if you could save a lot of time spent running countless scenarios and sensitivities when Excel could actually do it for you with the help of a smart macro? This is what the new tutorial released today will teach you do.
When you have only two variables that you want to change, it is easy you can just use a data table when you want to run several scenarios (see here), but when you have complete sets of assumptions that you want to test you cannot do so, you have to run them manually one by one... unless VBA can help you do so. What the tutorial will show you is how to tell Excel to run a repetitive task until all the scenarios have been run.
You can find this new tutorial here.