microsoft excel course - List management

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

Resolved · Low Priority · Version Standard

List management

Carol has attended:
Excel Intermediate course

by - delegate Carol [1 post] (2007 Feb 13 Tue, 09:41) Reply

What does this entail?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: List management

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 10:54) Reply

List management is where you would use lists to organise your data logically, also sorting lists by contents of their columns to show only tows that meet certain conditions and also it entails use of AutoFilter and Custom Filter.

RE: List management

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 10:54) Reply

RE: List management

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 10:54) Reply

· Microsoft Excel Training Course
· Database Tips from an Excel Training Course
· Reasons Why VBA for Excel Training Fails
· Basic Excel Training
· How to Create Better Excel Spreadsheets: Part Four

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