top of page

FILTER TOOL INTERMEDIATE

This page brings on a more sophisticated level what you learned in the first part of this course on the filter tool page.

Text/Value Filters

By utilizing Text/Value Filters in Excel, you can tailor your filtering options based on whether the data in a column consists of text, numbers, or dates.

For instance, if you wish to view results exclusively for resort names that begin with the letter "P," Excel provides a straightforward solution.

Filter based on cell color

A valuable feature of Excel's Filter tool is the ability to filter data based on color.

For example, if you wish to display only the rows in a table that are highlighted in yellow, you can easily achieve this by applying a color filter. Simply select one of the columns, choose the "Filter by color" option, and then specify the desired color to apply the filter.

Filtering using Excel Wildcards

Excel provides the functionality of using wildcards in filters, which can be quite useful.

There are two types of wildcards in Excel:

  1. The question mark "?" matches a single character.

  2. The asterisk "*" matches zero or more characters.

Let's consider an example where we want to filter rows containing "Euro Disney." In this case, there may be some rows with a dash between "Euro" and "Disney." To capture both variations in one filter, we can utilize wildcards. For instance, we can type "Euro?Disney" as the filter criteria. The question mark acts as a placeholder for any single character, allowing it to match both the space character and the dash character. This way, we can effectively filter for the desired rows using wildcards.

bottom of page