excel training - Filtering

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

Resolved · Low Priority · Version Standard

Filtering

Lauren has attended:
Excel Intermediate course
Excel Introduction course

by - delegate Lauren [2 posts] (2007 Jul 27 Fri, 09:54) Reply

How do i filter a table?

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

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 28 Sat, 06:59) Reply

Hi Lauren,

Thank you for your question.

You can filter a table by clicking within the table and using the AutoFilter menu. This can be found under Data > Filter > AutoFilter. This is where you get the drop down options to pick from a selection. There are other filters as well, but this is the easiest and quickest one to use. Have a go see if it works and if you get stuck just get back to me!

Tracy

· Advanced Excel Training - takes you to the next level
· Do You Really Need Excel VBA Training?
· Tips to Facilitate Printing of Excel worksheets
· Reasons Why VBA for Excel Training Fails
· Database Tips from an Excel Training Course

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips