Excel One Input Data Table

Data tables are really useful for doing a what-if analysis. The one input data table allows you to see the results quickly in a table based on changing the value of one variable. Rather than having to change the variable one at a time and making a not of the values a data table will allow you to view all of them in one go.

To see how a two input data table click here.

Here is a tutorial to show you how it works.