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.