Did you know you can find the data you're looking for quickly and easily using Excel's AutoFilter feature? For example, if you have a list of data that includes company names, types of products, and sales records, and you want to find all the companies that sell food products, you can apply an AutoFilter and then select "food products" in the column that contains that entry. All rows with other types of products are hidden, or filtered out, so that all you see are the records for food products. You can also find the companies with the top 10 sales records by applying a "top 10" filter. Here's how:

1. Click a cell in the list that you want to filter.
2. On the Data menu, point to Filter, and then click AutoFilter.
3. To display only the rows that contain a specific value, click the arrow in the column that contains the data you want to display, and then click the value you want to display in the AutoFilter list. To apply an additional condition based on a value in another column, repeat this step in the other column.
4. To show a top 10 list, click the arrow in the column that contains the data, such as a column of sales records. In the AutoFilter list, click (Top Ten...). In the Top Ten AutoFilter dialog box, click OK. Note that in the Top Ten AutoFilter dialog box you can set the top or bottom items in a list, as well as the number of items you want to show (which can be between 1 and 500). You can also show the top or bottom percentages in a list.