Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Excel Graphs
Worksheets Quick Functions Excel Sort
Edit Cells Excel IF Statement Excel Filter
Freeze Panes VLOOKUP Conditional Formatting
Excel Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid
Excel Training
Microsoft Word Training
Advanced Excel Books
About
Questions & Answers
Guestbook
Office 2007 Books
A Full Excel Course

Free Maths Games
Place Value Games for Kids
Online Rounding Game

microsoft word training

Working with the "Filter" utility in Excel 2007

Basic filtering
Filtering by numerical values
Filtering by texts
Filtering by dates
More examples of using Excel's filtering

You are welcome to have a look at my Free Math Games.


When should you use the “Filter” utility?

Whenever you have a big table, from which you want to show only certain rows that fulfill some criteria.

For example, in an employment agency you have a big table of job seeker’s personal details.
The details could be: First and last name, age, gender, marital status, phone number, home address, expected wage and of course - profession.


By using the “Filter” utility you can quickly bring up from your table and show:
All the job seekers that live in New Jersey.
All the seekers who are female.
All the seekers with the profession defined as: model.
All the Female models who live in New Jersey.
All the Female models who are single and live in New Jersey and are under the age of 28.
...The lawyer with the lowest “expected wage” in New Jersey...



Microsoft Ofice

Recommended Excel 2007 Books:


Website Statistics