Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo


What If Analysis Data Table in Excel

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: Del.icio.us  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.


© 2007 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media