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

Share and save this tutorial
Add to: Add to: Digg Add to: StumbleUpon Add to: Reddit Add to: Slashdot Add to: Technorati Add to: Netscape Add to: Newsvine Add to: Mr. Wong Add to: Webnews Add to: Folkd Add to: Yigg Add to: Linkarena Add to: Simpy Add to: Furl Add to: Yahoo Add to: Google Add to: Blinklist Add to: Blogmarks Add to: Diigo Add to: Blinkbits Add to: Ma.Gnolia Information

This tutorial is copyrighted .

Preferable reference for this tutorial is

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