How to create scenarios in an Excel model using Data Tables

Watch this video to learn how you can build modeling scenarios / sensitivity in Excel spreadsheet using Data Tables functionalities which is in-built in the software.

Scenario modeling is used extensively in any Financial Modeling exercise to provide potential outputs under different potential possibilities. So we need to assume different values of the input variables and predict the output variable for the each of the different input variables. This is exactly done using Scenario modeling in Excel.