List management

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

Resolved · Low Priority · Version 2003

List management

Wassila has attended:
Excel Intermediate course

by - delegate Wassila [1 post] (2008 Apr 24 Thu, 16:26) Reply

I still didn't quit understand how to use the advanced filter funtions, could you please explain?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: List management

by - trainer Tracy platinum contributer [586 posts] (2008 May 9 Fri, 05:21) Reply

Hi Wassila

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

To create an advanced filter, you need to have criteria set up so that Excel knows what to show in the filter results.

The criteria consists of the heading of the column you are getting Excel to look in; and what value you want it to find in that column. You can have multiple headings and values as part of your criteria.

For a simple and illustrated example of how to set up an advanced filter please see http://www.contextures.com/xladvfilter01.html

I hope this helps.
Tracy

· Identifying Suitable Candidates For VBA For Excel Training
· Prepare for your MOS Certification with MS Excel Courses
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Features and Functions for Accountants
· Do You Really Need Excel VBA Training?

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

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips