training excel vba - Football

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

Resolved · Low Priority · Version Standard

Football

Seth has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Seth [3 posts] (2007 Feb 26 Mon, 09:31) Reply

Will ManU win the title this year!?!?

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: Football

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 26 Mon, 10:05) Reply

Probably! Fulham fan myself and they beat us on Saturday!

Enjoy your training

· Interesting Lifestyle Applications for Microsoft Excel
· Compare Different MS Excel Training Methods
· Excel and Inventory Management
· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Three

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips