excel course in london - Using data tables to project values

Rachel,

The steps are:

1. Type the PMT formula into cell E6 as shown in the book.
2. Highlight Cells D6 to E21
3. Click DATA > TABLE
4. in the COLUMN INPUT CELL, click on cell B6.
5. Click OK

Data values will be projected.

Regards

Richard