Filtering in Excel (Basic Application

Filtering in Excel (Primary Application)

When it comes to filtering, it is commonly used in daily work. Select a table area and click the funnel icon of the filter in the Data tab, then we can see a drop-down arrow next to each field in the first row of the region. So far, we think filtering is very simple. Why do we still use so many words to describe the process of clicking a button?

650) This. width = 650; "Title =" 1.jpg" alt = "wKioL1O-PHGx5DfYAAMvR3SlRNA708.jpg" src = "http://s3.51cto.com/wyfs02/M01/3B/8B/wKioL1O-PHGx5DfYAAMvR3SlRNA708.jpg"/>

Let's take a look at it with questions. Take the birthdate column as an example. Click the drop-down menu and you will see the selection button before all date data for us to filter the corresponding year.

650) This. width = 650; "Title =" 2.jpg" alt = "wKiom1O-PK_TWNfBAAPq2cNIMrY606.jpg" src = "http://s3.51cto.com/wyfs02/M00/3B/8B/wKiom1O-PK_TWNfBAAPq2cNIMrY606.jpg"/>

But what should I do if I want to screen people who are born in the next quarter (such as the fourth quarter) so that HR can receive birthday benefits. You can see that the filter menu also includes some other options. In this example, we will use the date filter in the filter menu. In this menu, there are more built-in conditions for you to choose from.

650) This. width = 650; "Title =" 3.jpg" alt = "wKioL1O-PKWBhlNTAARWWhwygww055.jpg" src = "http://s3.51cto.com/wyfs02/M02/3B/8B/wKioL1O-PKWBhlNTAARWWhwygww055.jpg" width = "632" Height = "470"/>

Look, this is the filtering result,

650) This. width = 650; "Title =" 4.jpg" alt = "wKiom1O-POXwiU5kAAGwjwoE3cc512.jpg" src = "http://s3.51cto.com/wyfs02/M01/3B/8B/wKiom1O-POXwiU5kAAGwjwoE3cc512.jpg"/>

This is to filter by date features. Next we will use the features of other types of information to filter. For example, if you have a worksheet for personnel information, you need to search for a person's data, but you do not know the person's name or other information, but remember that his phone number contains two to 23 characters. What should I do?

This is the source table

650) This. width = 650; "Title =" Capture. jpg "alt =" wKioL1O-PMXDIBUZAAHIfKRhLGg476.jpg "src =" http://s3.51cto.com/wyfs02/M00/3B/8B/wKioL1O-PMXDIBUZAAHIfKRhLGg476.jpg "/>

In this case, step 1 is still based on the funnel, and then click the filter menu in the contact information column. We will filter them by text, then select "include" other "equals" and "end ".

650) This. width = 650; "Title =" 6.jpg" alt = "wKiom1O-PXPBnPfZAAhsLPw2Cpw833.jpg" src = "http://s3.51cto.com/wyfs02/M00/3B/8B/wKiom1O-PXPBnPfZAAhsLPw2Cpw833.jpg" width = "1109" Height = "602"/>

Enter your conditions and enter 23

650) This. width = 650; "Title =" 7.jpg" alt = "wKioL1O-PVbyRDVsAADnc0ZAl0Q464.jpg" src = "http://s3.51cto.com/wyfs02/M02/3B/8B/wKioL1O-PVbyRDVsAADnc0ZAl0Q464.jpg"/>

Look, you will remember that someone's phone number contains 23, and then excel will help you pick it out.

650) This. width = 650; "Title =" 8.jpg" alt = "wKiom1O-PZTz5SGGAAC-ezqeNiE554.jpg" src = "http://s3.51cto.com/wyfs02/M01/3B/8B/wKiom1O-PZTz5SGGAAC-ezqeNiE554.jpg"/>

In addition, depending on the data type in the column, the number filter is also included. For example, the work allowance column, you can screen out the top 10 in the same way.

The above content is not very basic. Some people have used it, and some others have never used it. In fact, Excel is willing to do anything for you, as long as you can communicate well with her. How to communicate? The above are some superficial button functions, just like between people, you can only gesture to communicate, so basically she understands, and then do simple things for you; if you have learned a word (which should be a few hundred functions in Excel), it will be much more convenient. You can better express your requirements, and she will better understand your needs, then we will do more for you. Further, we will use the language of the other party to express our meaning fluently (in Excel we should call macro VBA) and feelings, the other party can fully understand what you mean and understand your feelings. This is the highest level. At that time, you can let Excel do anything you think of for you (only what Excel should do)

Download the attachment for exercise questions.

 

 

 

 

This article from the "GUO Yong technology blog" blog, please be sure to keep this source http://guoyong.blog.51cto.com/408495/1436706