Filter Options

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

Resolved · Low Priority · Version 2007

Filter Options

Wayne has attended:
Excel Intermediate course

by - delegate Wayne [1 post] (2008 May 13 Tue, 15:27) Reply

What are the various filters available.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Filter Options

by - trainer Alan silver contributer [59 posts] (2008 May 18 Sun, 18:17) Reply

AutoFilter and Advanced Filter - both available in the DATA menu.

Our advanced course covers this and more...

· How to Create Better Excel Spreadsheets: Part One
· Tap the Power of Recorded Macros with MS Excel Courses
· Customized Financial Excel Courses in London
· How to Create Better Excel Spreadsheets: Part Two
· Take the Anxiety out of Domestic Finances with Microsoft Excel

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

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips