Perform "What-if" analysis with a 2 input Data Table

Here are the steps to follow in this video lesson:

1. Create a formula that references cells – e.g. =PMT(B4/12,B5,B3)
2. To the right of this formula cell, enter a series of “substitute” values – e.g. 36, 48, 72 months.
3. Directly below the formula cell, enter another series of “substitute” values – 4%, 4.5%, 5%, etc.
4. Select the range of cells for the Data Table – starting with the formula cell.
5. From the Excel Menu, choose Data, Table.
6. For the “Row Input Cell,” click the cell in the original formula for which you want to “substitute” the row values in your Data Table.
7. For the “Column Input Cell,” click the cell in the original formula for which you want to “substitute” the column values in your Data Table. Then click OK.

NEW! Download the Excel Workbook that I Use in this Video:

• cr-tutorial-20b-2-input-table

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.