Excel 2010: Filtering Data





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Feb 22, 2011


Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different in the way that it allows you to qualify and display only the data that interests you. For example, you could filter a list of survey participants to view only those who are between the ages of 25-34. You could also filter an inventory of paint colors to view anything that contains the word "blue," such as "bluebell" or "robin's egg blue."

In this lesson, you will learn how to filter the data in your worksheet to display only the information you need.

Filters can be applied in many different ways to improve the performance of your worksheet. You can filter text, dates, and numbers. You can even use more than one filter to further narrow down your results.

Watch the video to learn about filtering data in Excel.

If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/excel2010 to view the entire tutorial. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

  • Category

  • License

    • Standard YouTube License


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...