Excel is a software widely used in data management and processing, and the filtering function is a very common function in Excel. Through screening, we can quickly find the qualified data, so as to analyze and process the data more efficiently. This article will introduce the methods and skills of how Excel can quickly filter data.

I. Basic screening

Basic filtering is the simplest filtering method in Excel, and data can be filtered according to one or more conditions. The basic screening steps are as follows:

1. Select the data area to filter.

2. Click the Filter button in the Data tab and select the filter option from the drop-down menu.

3. In the pop-up filter dialog box, select the conditions to be filtered, such as equal to, greater than or less than.

4. Enter the numerical value or text of the filter condition in the Condition Value box.

5. Click OK to complete the basic screening.

Second, advanced screening.

Advanced filtering is a more powerful filtering method in Excel. It can filter data according to various conditions and directly output the filtering results to a new area. The operation steps of advanced filtering are as follows:

1. Insert a line above the data area to be filtered, and enter the filtering conditions.

2. In the newly inserted line, enter the conditions to be filtered, with each condition occupying one column.

3. Select the data area to filter.

4. Click the Filter button in the Data tab and select the advanced filter option from the drop-down menu.

5. In the pop-up advanced filtering dialog box, set the range of filtering conditions and the location of output results.

6. Click OK to complete the advanced filtering.

Third, automatic screening.

Automatic filtering is a shortcut to filter data in Excel, which can automatically filter data according to the contents of cells. The operation steps of automatic filtering are as follows:

1. Select the data area to filter.

2. Click the Filter button in the Data tab and select the Auto Filter option from the drop-down menu.

3. A drop-down arrow will appear above the column heading in the data area. Click the drop-down arrow to select the conditions to filter.

4. Enter the numerical value or text of the filter condition in the Condition Value box.

5. Click "OK" to complete the automatic filtering.

Four, the operator in the advanced screening

In advanced filtering, we can use various operators to set filtering conditions. Here are some commonly used operators:

1. Equal to: indicates that the data must be equal to the specified value.

2. Not equal to: indicates that the data cannot be equal to the specified value.

3. Greater than: indicates that the data must be greater than the specified value.

4. Greater than or equal to: indicates that the data must be greater than or equal to the specified value.

5. Less than: indicates that the data must be less than the specified value.

6. Less than or equal to: indicates that the data must be less than or equal to the specified value.

7.Contains: indicates that the data must contain the specified text.

8. Does not contain: indicates that the data cannot contain the specified text.

Five, the setting skills of screening conditions

When setting the filtering conditions, we can use some skills to improve the filtering efficiency. Here are some common techniques:

1. Use wildcards: You can use wildcards to match multiple characters in the filter criteria, for example, "*" stands for any number of characters, "?" Represents any character.

2. Use conditional format: Using conditional format in the data table can mark the qualified data, which makes it easier to filter.

3. Use PivotTable: PivotTable is a powerful data analysis tool, which can group and summarize data according to multiple conditions, making it easier to analyze and filter data.