How to create Excel Data Table

1.  In Excel 2007 / 2010, create the formula (ex: Profit Formula)

2.  The Profit Formula should be at the upper left cell of the Data Table.  You could set up a Two Variable Data Table (Price Per Room and Variable Cost) to look like this:

3.  Highlight the range of cells for Data Table

 

4.  Select Data / Table What-If Analysis / Data Table

5.  Enter Row Input Cell / Column Input Cell.  In our example, the row input cell should be Price Per Room ($C$2) and the column input cell should be Variable Cost ($C$4).

6.  The Data Table should be created after you select OK.  You may now perform What-If analysis.

 

More details regarding how to use Excel Data Table.  You need to have Adobe Reader to open the file.