Thu 19 Jul 2007, 12:13Delegate Rachel said...
Rachel has attended:
Excel Advanced course
Using data tables to project values
I was trying to redo what we did on the course yesterday (p13 in our booklets) and it wasn't working, what were the exact steps again please?
Thanks!
Fri 20 Jul 2007, 10:25Trainer Richard said...
RE: 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
