Filters in Excel

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

Resolved · Low Priority · Version 2003

Filters in Excel

Diana has attended:
Excel Introduction course

by - delegate Diana [1 post] (2008 May 12 Mon, 16:34) Reply

How are they used

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 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Filters in Excel

by - trainer Amanda platinum contributer [968 posts] (2008 May 15 Thu, 11:43) Reply

Hi Diana

Thank you for your question.

Filters are used when you are using Excel to store data in a series of columns, with a heading above each column, e.g. sort of like an address book where you would have First name, Last name, Street address, City, Postcode.

The filter allows you to get Excel to display only those items in your list that match certain criteria, e.g. with the address book example, you only want to see a list of people that live in London.

We do cover filtering and other list management tools in the Excel Intermediate course.

Kind regards
Amanda

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Advanced Excel Training - takes you to the next level
· Database Tips from an Excel Training Course
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Features and Functions for Accountants

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

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips