Don't believe it, word is better than excel sometimes!

It's not the amount of knowledge that matters , It's the quality of knowledge .

A person who really understands the nature of tools , In order to give full play to its great power !

—— Visenmo · Ramosa · Autumn leaves


The princess of the last issue 【 Autumn leaves PPT】 Word There is a question in the column :

How to align the information of Party A and Party B side by side in the contract ?


Actually , The quickest solution is to divide columns .


 Don't be incredulous ,Word Sometimes than Excel It works !

You may know what a column is . such as , Xiao Bian looks at the growing up 《 Reader's digest 》、《 A bosom friend 》、《 story-telling session 》 And so on , This kind of typesetting is often used .

Column layout , You can read line by line without turning your neck , It also makes the content more compact , Typesetting saves more space ( No paper ).

But , You know, Word、PPT Is there a column function in the library ?

Even know , Would you use it to align text with the same structure side by side ?



 Don't be incredulous ,Word Sometimes than Excel It works !


Xiaobian has a stock fan , He asked a question in wechat group :

I want to print a copy of Excel surface , It's all stock code information , There are only two columns , But there are 100 Multiple lines . If you print directly , There's a lot of space on every page , What a waste of paper . Is there any way to print these forms on a piece of paper ?

 Don't be incredulous ,Word Sometimes than Excel It works !


That's true. ,Excel Function formulas are almost omnipotent , You can rearrange the data according to the width of the paper with a formula . No matter what the reflexes are 、 Muscle memory , It's still international practice , I should let him search Baidu , I'm sure you'll find a bunch of tutorials .


 Don't be incredulous ,Word Sometimes than Excel It works !


But there is no , If he doesn't understand the formula , Come and ask me what to do ?!

Actually , There's a way , No functional formula at all , Just copy and paste , You can set it up to achieve a similar effect . you 're right , Is in the Word I want to borrow a way from you —— Columns .


 Don't be incredulous ,Word Sometimes than Excel It works !


You may know Word The function of the middle column . that , When it comes to this 「Excel」 The problem of the table , Would you want to use Word Separate columns ? still , Continue to Excel The formula of function is dead ?

although Excel Almost anything , The efficiency is amazing . however , A lot of times ,Word It might work better .


 Don't be incredulous ,Word Sometimes than Excel It works !


Want to be in Excel Make a copy of all provinces in China ( Autonomous region ) A list of , But only one text version was found , What can I do ?



 Don't be incredulous ,Word Sometimes than Excel It works !


stay Excel It's not hard to turn it into a list , Just sort by comma , It will be broken down into every province ( Autonomous region ) Fill in a row of data in a cell . Copy again , Paste special , Transposition , You can get a list of provinces .

But put it in Word in , It's going to be easier .


 Don't be incredulous ,Word Sometimes than Excel It works !


what ? To press 5 Line by line ?

It seems that it can only be put in Excel in , Using the power of the formula .

However , Many people don't know Word There's another stunt : Text to form , Can be converted by separator and specified number of rows and columns .


 Don't be incredulous ,Word Sometimes than Excel It works !


Word The work of word processing is wonderful , Good enough to be ignored by a lot of people . If you can be flexible Word Find replace for 、 Typesetting skills , It can even help you learn less Excel The formula .

However , A lot of people just want to use the form of large paragraphs of text content Excel To do it . thus , If the rows of the table are higher , When browsing the form, the screen will often jump around . and , When printing , It's normal , It can be printed on paper , But often the last two or three lines are “ eat ” What happened .

There is a , Another classmate came to ask why , I can't help it , ask :

「 I'm curious , Why do you have to use Excel To make this form ?」「 The leader asked for 」


I ,……



 Don't be incredulous ,Word Sometimes than Excel It works !


There's an audit girl , To print confirmation letters in bulk , I can't understand the intimate little tutorial of my predecessors. I came to ask .

But …… I don't understand the confirmation letter ~

So Baidu silently , It looks something like this :


 Don't be incredulous ,Word Sometimes than Excel It works !


It is based on Excel Information of each enterprise in the table , Print letters with different contents .

The elder sister left her operating instructions , Although the steps are clear ,4 Step by step , But the content is just like the book of heaven :


 Don't be incredulous ,Word Sometimes than Excel It works !


Also used. 「 Easy to use plugins 」 Batch generate and rename worksheets , And then batch printing is realized . I look so confused .

wait , Batch print notification 、 Correspondence 、 Payroll 、 Certificate of merit 、 Bookmarks and things like that , I'm not supposed to ask Word Are you on the stage ?

utilize Word Of 【 Merge mail 】, Just one piece of content left blank Word File as template , You can start from Excel The data of 「 Warehouse 」 Retrieving all data from , Automatically generate a document .

Then batch printing can be done ,1 We don't use any of these formulas , It's easy to do 1000 Documents !


 Don't be incredulous ,Word Sometimes than Excel It works !




Use brute force everywhere , The more you use it, the harder it gets .

Be familiar with the advantages and disadvantages of tools , Know how to use the characteristics of different tools , In order to deal with all kinds of complex situations !

版权声明
本文为[The style of ancient Taoism and Confucianism]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/02/20210222135223132b.html
相似文章

2021-08-09