microsoft excel training day courses near kent - advanced filter

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Advanced filter

microsoft excel training day courses near kent - Advanced filter

resolvedResolved · Low Priority · Version Standard

Maurice has attended:
Excel Intermediate course

Advanced filter

How do you advance filter

RE: Advanced filter

Hi Maurice

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.
Amanda


 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Server loaded in 0.09 secs.