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

The UK's most regular instructor-led training courses.
Training information: microsoft+excel+training · Excel course · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel - 1v & 2v data table

Jing has attended:
Excel Advanced course

by - delegate Jing [2 posts] (2007 Aug 18 Sat, 22:34) Reply

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!!!

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel - 1v & 2v data table

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 19 Sun, 14:17) Reply

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

· Microsoft Excel Courses Teach Advanced Macro Techniques
· From the Classroom to the Corporate World
· Advanced Excel Training - takes you to the next level
· Crazy Things People Have Done With Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips