What If Analysis Data Table in Excel

By Kardi Teknomo, PhD.

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

| Next >

Topics

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

See Also: Scenario Analysis

Share and save this tutorial

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. (2009) What If Analysis Data Table in Excel.
http://people.revoledu.com/kardi/tutorial/What-If-Analysis/