In this video I show you how to write a macro in VBA (Visual Basic for Applications) so that Excel can run your probabilistic sensitivity analysis (PSA). I share tips for how to get it running as fast as possible.

Note - After recording the video I noticed a small error. On the parameters sheet, for cell F11 we should have '=BETA.INV(RAND(),60,40)' not '=BETA.INV(RAND(),90,10)'. Apologies for that!