Excel tips: Excel How to effectively improve work efficiency

Excel tips: Excel How to effectively improve work efficiency

1. Two items check

Two tables of data need to check out what is the same, when the data are many when the hook needs a long time, in fact, only need a small formula to be done immediately.

=countif (D:D,A2)

Note: A value of 1 is a duplicate.

2, find duplicate values

In the face of a tens of thousands of-line customer information table, if you want to find a duplicate line, manually estimated a day can not find out, then you only need:

Select Columns-Start-conditional formatting-highlight cell rules-duplicate values.

3. Delete duplicate records

Once a colleague of the customer service department asked me to do a favor, the original leader let her to the customer consumption record repeated lines deleted, a customer only protect one row. She said that the deletion was not completed for several hours. In fact, this work will only take a few seconds to complete.

Select Region-Data-deletes duplicates.

4, intercept the characters in parentheses

As shown in the following illustration, you need to extract the contents of the brackets. It looks like only hand-edited. In fact, there are many ways to batch processing, the fastest is the replacement.

Find * (, replace with NULL, find) *, replace with NULL.

5, save the picture in Excel

There are a lot of inserted pictures in the Excel table, and if you want each picture to be saved as a file. Are you using screenshots to cut the software? There is actually a very simple way.

FILE-Save As-Web page format, the picture will be automatically saved as a picture file.