Data table or sometimes called What-If table in MS Excel allows us to compute many outputs from a series of input of one variable, or compute single output variable from variation of two variables. In this tutorial I will show step by step with a very simple example how to create data table with one input variable and two input variables.

Data Table with One Input Variable
Data Table with Two Input Variables
Scenario Analysis

download the MS Excel file as companion of this tutorial