In this lesson you will learn how to use Excel’s AutoFilter to reveal select data records that match your filter criteria.
Here are the steps to follow in this lesson:
1) Organize your list into Columns / Fields that contain a single type of data e.g. Territory
2) Apply a different format to identify the Top Row of your list as the Column Headers
3) Select one cell in the list then choose DATA – FILTER – AUTOFILTER
4) Use the “drop-down” arrow for a field to select your filter
5) The Top 10 Filter is a generic term. e.g. You can filter to Bottom 15items / percent
6) Custom filters allow you to see records that are <, <=, etc.
Find the video lesson that you want – Index to all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Related Videos
Related Video Lessons
Link to this post!
Hello there, You have performed a great job. I’ll certainly digg it and personally suggest to my friends. I am confident they’ll be benefited from this website.