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
Topics
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.
http://people.revoledu.com/kardi/tutorial/What-If-Analysis/