Welcome to Excelling with Excel 2007

Working Smarter

Database and quiz
there is a database assignment to complete first and then the quiz - remember to email me for the database and then the quiz

So far you have sorted and done some filtering of information. Now, you will do a custom filter. What does a custom filter do? What if you looked at your list and wanted to know who lived in Palo Alto and Redwood City and have that information come up in a list?

You can do this too - this is where you use a custom filter.
Remember - we have taken a database and done an autofilter. To do a custom filter you need to have completed an autofilter.

The steps: you really have to do this to see how it works

• click on the arrowhead beside the label you want to custom filter. This means if I were working with cities and I wanted to know all the people who lived in Redwood City and Palo Alto I could do that with a custom filter
• select NUMBER FILTERS and select a filter option (Equals, Great Than, etc.). Click OK.

Diagram 1:

Diagram 2:

there is more - NEXT

Quiz

email me for this project

SMILE, you have completed the introductory part to EXCEL. You are now ready to pursue the more advanced features of Excel. You can do this by clicking on the words Moving On that you see right here OR you can select Moving On from the navigation bar at the bottom of the page.