Data tables are another of Excel’s tools for what-if analysis. It allow you to change two variables and display the results in a table so you can quickly determine the optimum result for you or to easily compare outcomes. Without the data table you would have to change the values and make a note of the outcome. This way it is easy to see results in a table.
To see how to use a one input data table click here.
Watch the tutorial below to see how to use a two input data table.