Share this: Google+
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. You can download the MS Excel file as companion of this tutorial
See Also: Scenario Analysis
Preferable reference for this tutorial is
Teknomo, Kardi. (2009) What If Analysis Data Table in Excel.