excel-training-course

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

excel-training-course - Filter

Filter

Antonia has attended:
Excel Intermediate course

by - delegate Antonia [1 post] (2008 Jan 25 Fri, 17:02) Reply

How to use advanced filter
Any suggestion on scenarios to use filtering

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	2	book now	£495	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: filter

by - trainer Amanda diamond contributer [1243 posts] (2008 Feb 7 Thu, 10:25) Reply

Hi Antonia

Thank you for your question, and apologies for the delay in response.

Filtering is used to be able to reduce down the amount of information that you can see from a list/table in Excel. If you are looking only for rows of data that contain specific information (criteria) from a certain column or columns, then you can apply a filter to temporarily remove from view any rows of data that don't contain the criteria you are looking for.

Most filtering can be done using the AutoFilter feature (Data - Filter - AutoFilter) where you use dropdown arrows at the tops of the columns to be able to select the criteria that you are looking for from a specific column or columns.

The advanced filter is used when you are looking for very specific criteria, that you would not be able to display using the AutoFilter. For example, if you were looking for three different criteria from one column - AutoFilter will only let you display two criteria from a column.

I hope this helps.
Amanda

excel-training-course - Filter

Related articles

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.