excel

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

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

Excel 2007

resolvedResolved · Low Priority · Version 2003

Pat has attended:
No courses

Excel 2007

What is advanced filtering?

RE: Excel 2007

Hi Pat,

Thank you for your question.

Advanced filtering is used to extract data from an excel list organised in columns based on multiple criteria.

It involves copying the headings, typing the criteria under those headings and applying the criteria to the main list.

I hope this answers your question.

Regards

Simon

Fri 6 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips


Server loaded in 0.09 secs.