98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Excel - 1v & 2v data table
microsoft+excel+training - Excel - 1v & 2v data table
Resolved · Low Priority · Version Standard
Sat 18 Aug 2007, 22:34Delegate Jing said...
Jing has attended:
Excel Advanced course
Excel - 1v & 2v data table
I had attended the Advanced Training course on 17th Aug 2007 at Southwalk centre, but forgot already how to use 1v data table and 2v data table.
Peter, please forgive me for my short memory - I have reviewed all the lecture examples and gone through all practices, everything is fine except 1v & 2v data table. Help!!!
Sun 19 Aug 2007, 14:17Trainer Tracy said...
RE: Excel - 1v & 2v data table
Jing,
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
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Status Bar FunctionsWhen using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet. |
