Shulou(Shulou.com)11/24 Report--

Today, Mr. Wang is here to share with you some practical tips on Excel, which can effectively improve your work efficiency.

High-end picture tips Excel annotation function can not only add text description, but also can add picture tips, in the production of some personnel information, contact information and other forms, picture description can play an unexpected role!

Circle the data we want. in a large amount of data, how can we quickly circle the data we want to see? For example, here I want to circle all the scores below 60. First, we have to set a data range. Select the data, click "data"-"data tools"-"data validation", "allow" to select "integer", "data" select "greater than or equal to", and finally set the value (you can set it according to your own needs). Finally, we can click "Circle invalid data".

Filter and copy data in a large number of data, we want to filter and copy the data information of several designated people, which is a troublesome thing. Through the advanced filtering function, it can be screened out in minutes.

Merge the contents of the cell we enter "=" in the edit bar, and then select the area, after the selection is completed, we press the "F9" key, its function is to display the formula operation results. So at this time, the edit bar will show the contents of all the cells, as long as we copy all the contents in parentheses, and finally use the replace function, we can quickly get all the content, and have been separated for us. If you don't need to be separated by a comma in the middle, you can also replace it.

Merge summary for multiple tables with the same name and different data summaries, we can enter "data"-"data tools"-"merge calculation", one by one to add data information in multiple tables, we can quickly get the summary data we want.

Fast deduplication if you have a lot of duplicate data in your Excel, then we can use advanced filtering features to help us finish the deduplication work quickly.

Displaying thumbnails allows Excel files to be displayed as thumbnails, which makes it easier for us to find certain table files.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.