Excel

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

Resolved · Low Priority · Version Standard

Excel

Maria has attended:
Excel Intermediate course

by - delegate Maria [1 post] (2008 Feb 26 Tue, 17:04) Reply

Please go through Advanced formatting with me again?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Rich platinum contributer [711 posts] (2008 Mar 1 Sat, 10:18) Reply

Right click on the cell that you want to format and select format cells. There are various tabs which allow you to put different kinds of formats on individual cells.

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part Three
· Tap the Power of Recorded Macros with MS Excel Courses
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

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

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