Filters

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

Resolved · Low Priority · Version Standard

Filters

Sue has attended:
Powerpoint Advanced course
Excel Intermediate course

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

How do I use an Advanced Filter?

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	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
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: Filters

by - trainer Mara silver contributer [73 posts] (2008 Mar 2 Sun, 18:44) Reply

Hello Sue,
I hope you enjoyed your Excel training session with us.

Advanced filtering is a good option when a simple Autofilter will not allow you to get the detail you require. As you know, the Advanced Filter is a topic covered in our Excel Intermediate course, but here is a good example of how to use the Advanced Filter:

http://www.contextures.com/xladvfilter01.html

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Reasons Why VBA for Excel Training Fails
· Compare Different MS Excel Training Methods
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How to check for and reduce errors in Microsoft Excel

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

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips