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.

Vincent

Featured Posts
Recent Posts
Follow Us
Search By Tags
Archive
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

Financial Modeling Academy

  • LinkedIn App Icon
  • Wix Facebook page
  • Wix Twitter page