In Excel, you can filter a DATA set based on the kind of data.

The following types of data FILTERS are available in Excel:

• Text Filter
• Number Filter
• Date Filter

You can apply filter to a data set, by selecting the data, then clicking the HOME TAB and clicking on the Filter icon.

When you have tabular data and you apply filters, based on the data in the column, Excel shows you the relevant filter.

For example: if you have text data, it will show you filters related to text (such as text contains, BEGINS with, ends with, etc.).

In Excel, you can filter a data set based on the kind of data.

The following types of data filters are available in Excel:

You can apply filter to a data set, by selecting the data, then clicking the Home tab and clicking on the Filter icon.

When you have tabular data and you apply filters, based on the data in the column, Excel shows you the relevant filter.

For example: if you have text data, it will show you filters related to text (such as text contains, begins with, ends with, etc.).