You can use AutoFilter to analyze the data in your Excel spreadsheet based on specific criteria. For example, if you are an instructor with a list of students and grades, you can use AutoFilter to easily see which students have grades below 70.  Here’s how to use this feature: 

1. Click a cell in the list you want to filter. .
2. On the Data menu, point to Filter, and then click AutoFilter. Arrows appear at the heading of each column.
3. Click an arrow, and choose your filter criteria from the drop-down menu. (For example, you could filter for a number that's greater or less than a target figure.) Only rows containing data that meet the criteria are displayed. Great for reporting!