How to quickly learn and master office Office software?

stay Office In front of office software, I dare say this software knows everything, People who know everything, I dare say, I can't find one in the whole China.

that, How can we quickly learn and master office What about office software?

one, Office Three software PPT, Excel, Word Which one to study first?

The answer is no, Instead Outlook, Send and receive email, Do you need to learn this thing? Most people can "Become a talent by self-study" , EQ Higher people will understand the sending etiquette of e-mail.

It should be noted that Outlook Many functions of are related to email sending etiquette, Everyone should be "understand" !

What about the second place? It depends on the needs of your job position! For example, the administrative clerk may Word Used quite a lot, For data analysis and management Excel More, For sales marketing or manager level PPT More. For employees PPT Most of them are for work reports.

What is more interesting is IT Engineers often use Word There are also many, Because we need to write system maintenance documents to customers, Can't play Word Will be crazy by multi chapter typesetting, It's legendary 1. 1, 1. 1. 1, That thing.

summary, Master the software first according to the software with the highest frequency of use. Excel Highest training demand, The second is PPT, Finally Word.

two, If the software to be learned is determined, How should we start?

This question has to be mentioned, Software "personality" Problems of, To put it bluntly, it's a routine, There are routines for learning anything, That is what we call the method, Methods of learning a professional skill, In fact, this routine should be cultivated in college education, As a college student "basic" Ability is to quickly master new skills and methods related to this major.

But you all know our university education in China, So almost all job applicants will swear on their resumes: Proficient in office software. I was also a part-time interviewer for a few days, A question I often ask job seekers, If there are ten in the folder Excel workbook , How to open them all at once? Almost no solution can be found? Because this is not a Office problem! Do you know? The method is simple, Select these ten workbooks, Just hit the car.

Word learning method

First, understand the "personality" . First, let's talk about Word. study Word It must be a connecting link, Get it done at one go. what do you mean? Skill and skill are linked, There is a problem with the previous operation, It will affect the subsequent operations.

According to the pyramid results in the following figure, The more top also "high-end" !

Most people's level is even lower in the page setting stage, More people may use it to type and store text content, It can be achieved through systematic learning "Advanced typesetting automation" level, That means you can make the company's documents into format templates and call them directly, This has greatly improved the efficiency of copywriting.

As for more high-end "Advanced comprehensive application" , Just master "Mail merge" that will do. But it's easy to say, The powerful function of mail merge can help you learn it well for a few days, master "letter" and "label" That's enough for you, Of course, if you can output to outlook It automatically generates emails and sends them out, That would be perfect.

(Word There is a special mail panel, It is enough to show the power of this function)

So make sure Word Learning as a "whole" To learn, And it must be systematic learning, Learn the so-called decentralized Word antic, Overall Word The office improvement effect is not obvious.

Excel learning method

Excel The personality of this software is versatile, All aspects of him can be achieved "system" , It is easy to understand from the figure below, each "system" Can solve a level of problem, That is to say, if it is used in work Excel You can't fill up where you lack, If it's all missing, Just make up for it all, Everyone can understand a little, Don't play too deep, It's enough to cope with the work. such as Excel Not at all, Then learn the operation skills of table sorting. If data analysis doesn't work, School data analysis. If the boss has requirements for the chart, Then make the chart well. Of course, if you put Excel Make a template, That function is indispensable, Of course, mastering several common functions will also double the work efficiency.

If you can play VBA, You are the super God cow man (IB use) .

To sum up, Excel He is a versatile man, Make up for what is missing, "system" Comparative equality, Linkage between skills Word less, But the matching between functions and skills is also important, For example, a certain function and a certain function can solve certain problems, and so on, It can even be put into a certain working scene, Otherwise, everyone will have a problem? Why should I learn this skill? Does this skill have anything to do with me?

The last thing I want to say is, Excel This software is currently developing towards the idea of big data docking, For example, you can work with SQL The database directly loads and reads data, Such as integration PowerBI Such powerful data business intelligence analysis, These are all used in professional fields.

If you are proficient in the previous skills, you can understand and learn this part, Give Way Excel Become your work IB (install B) sharp weapon.

PPT learning method

PPT This software is a little "Concealed" Personality of. This software is three major Office In office suite, One of the software with the least number of buttons on the panel, after Outlook, But this software is necessary in the workplace, Necessary for work report. The requirements are higher. It is used for demonstration when selling externally, Require higher marketing department to do product release, etc, Need to use more professional design PPT requirement, Some requirements have been exceeded PPT Own needs.

PPT The advantage of this software is, Realize professional demonstration expression with relatively simple operation. But some PPT Enthusiasts will overuse this software, Cause in order to achieve an effect, And waste a lot of working time.

Without mastering PPT Before Meitu design drawing, Focus on PPT Logical expression of copywriting, combing and PPT This software is practical, That is, the first two stages in the figure below.

If you have a preliminary understanding of the functions of the software, Can start learning PPT Part of design, In fact, it is the operation of text mixing, At this time "Graphic Artist Designer" And even "Three dimensional design concept" Will be introduced.

There is no bottom line in the study of design, Because everyone is right PPT There is no end to the standard of beauty, Therefore, it is only necessary to meet the aesthetic standards of general graphic design. Learn the standard design idea and layout.

What's interesting is, PPT There are many so-called design aspects ppt The part that masters are good at playing, Because he has no standard, So you can play at will, So the quality of the tutorial varies from person to person.

So you'll find most PPT All tutorials will focus on "To put PPT Good looking" This level, But in the actual workplace, it may PPT Logical expression and copy preparation of, than PPT It's more important to look good.

Finally, let's talk PPT Animation part, If this part is taken out and studied separately, Can be divided into several levels, General understanding, "animation" There are two general functions of, One is to control the speaker's speech process, The second is the decomposition and demonstration of complex graphics or processes, Help the audience understand how it works.

If you want higher order, Can be PPT Animation and switching function of "trailer" , This skill is not cold in a day, But there are also ideas and skills to follow, But the probability of using it in the workplace is relatively low, You can find a professional advertising company, No need to learn by yourself, usually PPT Enthusiasts can study by themselves.

three, I have learned all three software, How to use it?

If you are proficient in the three softwares, you should learn to coordinate with each other, such as PPT The copy content of can be passed Word Organize and import.

Excel The data of can be Word Mail merge for later copy processing. Excel The chart of can be easily connected with Word or PPT Update data, etc, Such cooperative working skills will also greatly improve work efficiency. That's the same sentence, Office Three major pieces learned to be useful for life, Even my mother uses it Excel To record the daily shopping, Make a ring chart analysis, and the proportion of the amount of selling meat, fish and vegetables has been adjusted appropriately.

Recommended for everyone Excel Manage shopping bookkeeping, You'll find out, Many things that you can't buy are really unnecessary, Before making the first pot of gold, Money must have been saved. So don't be called "The theory that money is earned is fooled" . How to make money without accumulation?

That's all for today, Hope to think about systematic learning Office My little friend is helpful.