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

excel training courses - advance filter

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Advance filter

excel training courses - Advance filter

ResolvedVersion Standard

Tanya has attended:
Excel Intermediate course

Advance filter

not sure how to use this feature

RE: advance filter

Hi Tanya

Thank you for your question.

To create an advanced filter, you need your list/table and your criteria set up in your spreadsheet.

For a detailed explanation, I would suggest looking up 'Filter by advanced criteria' in Excel Help.

Amanda

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.