filters
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filters

Filters

resolvedResolved · Low Priority · Version 2003

replyReply Thu 14 Aug 2008, 16:08Delegate Karen said...

Karen has attended:
Excel Intermediate course

Filters

what is an advanced filter?

For upcoming training course dates see: Pricing & availability

replyReply Tue 19 Aug 2008, 13:11Trainer Stephen said...

RE: filters

Hi Karen

Thank you for your question

An advanced filter is a simple technique that allows you to filter a list by multiple criteria.

You start by creating a criteria area in your spreadsheet that contains the column headings of the fields on which you wish to filter, and the criteria underneath the field headings.

You then click inside the list to be filtered and select data-Filter-advanced filter to run the adanced filter wizard

Hope this helps

Regards

Stephen

 

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

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard