It's today 3 The last day of a long holiday , I'm going to work tomorrow . Believe in the hearts of many people right now OS yes ： We have to face the complicated Excel Tables and Word 了 ！
Don't worry , I'll recommend it to you today 2 It's a great one Word and Excel plug-in unit , Greatly improve your work efficiency ！
1、 Omnipotent EXCEL plug-in unit ： Square lattice
Square grid is my most common EXCEL plug-in unit , It has... Built in Text processing 、 Batch entry 、 Delete tool 、 Merge and transform 、 Duplicate value tool 、 Data comparison 、 Advanced sorting Waiting for hundreds of practical functions .
? You need to 3/4/5/6 A step , Even remember the operation of multiple formulas . Now it's all a fool's one button operation , Efficiency improvement 100 times ！
It has so many functions , I'd like to give you a brief introduction to some commonly used ：
Dealing with forms , I think you all have this experience ：
? In a pile of data, you want to look at someone's information carefully , It's torture .
And now you can ：
? use 「 Spotlights 」 Direct lock information , It's very convenient to check ！
To extract in bulk
If you need to extract numbers in a text box now , of 「 extract 」 Of EXCEL How many people remember ？
MID( text , start_num , num_chars )
It's too hard, right ？ Now it can be done with one click ！
for instance ： Extract the numbers from the table below as 「 Area code 」 A single column ：
It's done ！ No foundation is needed ,1 We're going to extract the numbers in seconds .
Of course , In addition to digital . Same method , Space 、 english 、 Symbol 、 Can be extracted with one click ：
It's similar to this one , In a text box , All kinds of unnecessary content , Can be filtered out . Just choose... In the execution action 「 Filter 」 Just OK 了 .
for instance , Delete the number in the first column of the table above ：
? It's also one click deletion . Of course , Extra space in the table , Even garbled symbols . Can be quickly deleted in this way ！
2、 Small dinosaur official document typesetting assistant
This plugin , It was originally designed for the rapid creation of official documents . What is an official document ？ Like this red header file ：
But our daily work , It doesn't seem to have much to do with official documents .
Actually , It's in In ordinary documents , It also has a big effect . Just a few simple examples .
Sometimes we copy text from other places to Word in , Meeting There are multiple spaces or blank lines , I don't even know what it's called ↓：
If you don't master Word Basic knowledge of , It's very cumbersome to delete one by one manually .
And this little plug-in , It can be done in a few simple steps ：
In addition to deleting the blank area of the copied content , just so so Remove the space used for indent on the first line .
also , It also has a lot of powerful features , such as Convert Chinese and English characters , Remove hyperlinks etc. ：
This function is useful for those , Content copied from the Internet is particularly useful .
in addition , Delete header with one click 、 Gatting's title style , Can be implemented in this plug-in ：
The above two plug-in packages , I'm ready for you .
Pay attention to me @PPT Rhapsody , Private key words 【 Office plugins 】 Can get ~