0 of 15 lessons complete (0%)
Data Tables in Excel

Single Variable Data Table in Excel

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.