Vlookup

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

Resolved · Low Priority · Version 2003

1 post

ReplyWed 24 Jun 2009, 14:08Delegate Phil said...

Phil has attended:
Excel Intermediate course

Vlookup

Does the Advance Excel training course feature Vlookup?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	1		£224	£225
2003	Thu 18 Mar 2010	Limehouse	0	FULL
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	6		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 79 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

642 posts

ReplyWed 24 Jun 2009, 15:28Trainer Simon said...

RE: vlookup

Hi Phil,

Thank you for your question and welcome to the forum.

The Advanced course does cover Vlookups.

Please find below a link to the course outline:

http://www.microsofttraining.net/excel-training-in-london-2003-advanced.php

I hope this answers your question.

Regards

Simon

Wed 1 Jul 2009: Automatically marked as resolved.

· What's mine is yours: Sharing data in Excel
· Microsoft Excel can ensure you keep on top of your finances
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Charting Another Dimension With Excel
· Improve Performance Of Your Excel Macros

Please browse our web site to find out more about
introduction excel training and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Vlookup

Vlookup

RE: vlookup

Related articles

Excel tip:

Entering text in Multiple Worksheets