Filters

Hi Kelly, thank you for the post, welcome to the forum, I hope you enjoyed your course; in answer to your question, using the filter command in Excel is quite an indepth operation with lots of different areas;
Excel enables you to filter the rows that appear in your spreadsheet. For an example lets consider a stock worksheet that produces data from several dozen companies, you can filter to view one or more companies at a time, or you can filter by more than one column at a time. For example, you can apply a filter to find the companies with great growth rates, then filter for companies with strength (low debt, good inventory turnover ratios, etc). Filtering rows is faster and more flexible than changing criteria in a stock screen, so it's a great way to see which companies keep showing up as you look for particular characteristics.
Follow these steps to define and refine filters:
1. Select a cell on the spreadsheet