Excel 2007: Using Data Filter to retreive data quickly

Using the data filter option in Excel will allow you to quickly and efficiently “retreive” desired data based on the criteria you want.

In Excel 2007:

Tip: All columns must have a header (name) before applying the filter

In cell A1 go to:

Data>Filter (the funnel icon)

Once you have applied the filter you can then select the “arrow” to select only the desired data (by column). You can filter down even further by selecting another column and applying the filter to that desired data as well.

About Michelle Mangen

Michelle Mangen is a single-mom of a son who always makes her laugh (when he's not arguing with her) and owner of Your Virtual Assistant in Neenah, WI. Your Virtual Assistant provides virtual services to small business owners who realize that not only can they not do it all in their business but also realize that their time is better spent on the tasks that provide them with the greatest return on their invested time. She can be found on Twitter as @mmangen