Still balding for word and excel? These two office artifact, free and powerful
Whisper 2021-06-04 10:33:46

 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 !


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 .


 Still for Word and Excel bald ? These two office artifact , Free and powerful

? 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 :

Spotlights

Dealing with forms , I think you all have this experience :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

? In a pile of data, you want to look at someone's information carefully , It's torture .

And now you can :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

? 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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

Batch filtering

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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

? 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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 ↓:


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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. :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

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 :


 Still for Word and Excel bald ? These two office artifact , Free and powerful

Last

The above two plug-in packages , I'm ready for you .

Pay attention to me @PPT Rhapsody , Private key words 【 Office plugins 】 Can get ~

Please bring the original link to reprint ,thank
Similar articles

2021-08-09

2021-08-09