Single Variable Data Table in Excel

Please sign up for the course before starting the lesson.

In our opinion Data Tables is one of the best tools in Excel, both for running sensitivities and for repeating calculations in operational models.

To see its benefit consider the example below.

We have a property that we want to purchase and we have put the salient details in a model and calculated the monthly repayment and the total interest paid over the period. But we want to see what these will be at different interest rates as shown in the red circle. We could change the interest rate and copy/ paste as values the answers but what happens when the details change, and this is time consuming anyway.

single-variable-data-table-in-excelA single variable data table will solve this.

To see the full course contents click here.

Back to: Online Financial Modelling, Budgeting and Forecasting Course > Running What Ifs