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

ResolvedVersion Standard

Sat 18 Aug 2007, 22:34 Delegate 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:17 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

microsoft+excel+training - Excel - 1v & 2v data table

Excel - 1v & 2v data table

RE: Excel - 1v & 2v data table

Excel articles

Excel tip:

Bracketed negative numbers