By Kardi Teknomo, PhD.

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


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

See Also: Scenario Analysis

This tutorial is copyrighted .

Preferable reference for this tutorial is

Teknomo, Kardi. (2019) What If Analysis Data Table in Excel.