Todays training

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

Resolved · Low Priority · Version 2003

1 post

ReplyThu 7 Jan 2010, 16:28Delegate Alice said...

Alice has attended:
Excel Intermediate course

Todays training

I will probably have questions regarding v look ups at a later date!
Thank you for today
Alice

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	1		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

1,055 posts

ReplyFri 8 Jan 2010, 09:14Trainer Andrew said...

RE: todays training

Hi Alice

Thank you for posting to the forum. We look forward to your questions in the future!

Kind regards,
Andrew

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Compare Different MS Excel Training Methods
· Interesting Lifestyle Applications for Microsoft Excel
· Which Is Better, Excel Or Access?
· Interesting Things About Charts In Excel 2003

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

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips