Run multiple scenarios in one click

May 13, 2015

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

 

 

Please reload

Featured Posts

Launch of the Financial Modeling Academy

February 23, 2015

1/1
Please reload

Recent Posts

September 1, 2016

March 19, 2015

Please reload

Follow Us
Please reload

Search By Tags
Please reload

Archive
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

Financial Modeling Academy

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