What is the order of Excel learning?
Changzhou SEO is 2020-11-25 21:41:08
Dry only

One : Basic operation

First , You need 「 Fast will excel Go through the buttons in the menu bar above 」, It's better to move your hand and press each button several times . This can help you get familiar with excel, understand excel What functions does it have . In fact, most people are right about excel Is not familiar with , Always flip through the menu bar when you want to do something , It's a waste of time . So this step is very necessary . After finishing, the next step is to understand excel Some basic knowledge and basic operation methods in .

EXCEL What's the order of learning ?


At this stage, you need to master the following :

●Excel Basic knowledge points ( Ribbon commands / Enter text type / The essence of time / Paste special )
● Worksheet operations ( name / add to / Copy / hide / Delete )
● That's ok 、 Column basic operations ( Choose / Delete / hide / Adjust spacing )
● Basic operations of cells ( Input / Choose / Merge / Cell formatting / Comments )
● The basic operation of printing ( Print settings / Output PDF Format / Page setup )
● Be familiar with the location of each command and master the basic operation ( Screening / frozen / Sort )
● Master some of the most commonly used shortcut keys

Completing the above means that you have arrived excel Entry level . It can be used excel The simplest data processing .

Let's give you some basic knowledge :

Shortcut list :

EXCEL What's the order of learning ?


「F4」 Shortcut key , Repeat the previous command . For example, if you want to insert an empty row in a table , Click once and press F4 It can be inserted repeatedly .

EXCEL What's the order of learning ?


3.「ctrl+F」 Shortcut key , Quickly find and replace . For example, find out the wrong words and replace them .

EXCEL What's the order of learning ?


4.「Ctrl+Shift+ Arrow direction 」 Shortcut key , Quickly select the data area . for example 「Ctrl+Shift+ Down arrow 」 You can select a whole column of data , You don't need to drag the mouse to select . Other directional keys are the same .

EXCEL What's the order of learning ?


5.「Ctrl+G」 Shortcut key , Directly locate what you need to find . For example, to change the format of all numbers , Can press ctrl+G, Selection number , You can select all the numbers in the table .

6.「Ctrl+A」 Shortcut key , Quickly select the current entire data area , Press twice in a row ctrl+A The entire worksheet will be selected .

EXCEL What's the order of learning ?


Two : Advanced operation

In the second stage, we need to master some functions that are often used in our work . Use a picture to show :

EXCEL What's the order of learning ?


This stage , The most important thing is to do it yourself , Emphasize important things three times :「 Hands on operation ! Hands on operation ! Hands on operation !」 Many functions in the video are very simple to operate , But if you don't deepen your impression through practice , It's easy to forget . It is recommended to operate each function that is not commonly used , Make an impression in your mind , In the future, you can look at the video or surf the Internet again , Efficiency can be improved a lot . For the commonly used functions in the work, practice several times , After getting familiar with it, I can't forget .

As long as you are familiar with the above advanced operations , You've gone beyond 80% Colleague , In the work 90% You can solve all the problems . By this time you have basically said goodbye to overtime , With luck , There may have been a rise in the value of salary .

For example, a few basic functions :

1.sum Sum function .Excel In the most basic , The most frequently used function . The method of use is invincible and simple , Enter... In the cell sum function , Then select the sum area and press enter .

EXCEL What's the order of learning ?


Here's another Fast sum Methods , Click the auto sum option at the start , The system will automatically use sum Summation of functions .

EXCEL What's the order of learning ?


2.IF function .IF The input form of the function is IF(logical_test,[value_if_true],[value_if_false]), The adult translation is IF( Judge the condition , What to output when the conditions are met , What content is output when the condition is not met ).

For example, when sales exceed 2000 Yuan time , Put forward to be 200 element , Otherwise, Commission 10 element . Now you can go through if Function to quickly complete the operation . Just type in =if(B2>2000,200,10) that will do .

EXCEL What's the order of learning ?


3.sumif Conditional summation function .sumif The input form of the function is sumif(range,criteria,【sum_sange】) The adult translation is sumif( Judging the conditional region , What are the conditions , Areas that need to be summed up ).

For example, I want to know all about A What's the total sales of employees in this category , I can use sumif Function to quickly get .

EXCEL What's the order of learning ?


What needs to be noted here is , When you need to input characters such as text in the formula, you must add double quotation marks in English state , Like in the example above A Classes need to be written as "A class ".

4.vlookup Lookup function . The fighter in the function . The function is to find the corresponding value in a whole column of data . The input mode is vlookup(lookup_value,table_array,col_index_num,[range_lookup]), The adult translation is vlookup( Value to find , Search area , Find out which column to output after , Exactly or casually ).

For example, find out what the commission rate is based on the sales of employees .

EXCEL What's the order of learning ?


EXCEL What's the order of learning ?


5.match Lookup function , The function is to return the location of the specified content . You can find the number of digits in a row or column . The input form of the function is match(loop_value,look_array,[match_type]). The adult translation is match( What are you looking for , Where to find , What kind of ). For example, find the number of sales employee in the list .

EXCEL What's the order of learning ?


If the search content needs to merge the contents of different unit cells , It can be used & The symbol connects , Be careful , Any character entered in the formula should be enclosed in double quotation marks in English , As shown in figure of "-".

EXCEL What's the order of learning ?


6.index function , The function is to return the value at the intersection of row and column in cell range or array . The input mode is index(array,row_num,[column_num]). The adult translation is index( Which area to look for , Lines , The first few columns ). For example, to query the postage of items of different sizes and different regions .

EXCEL What's the order of learning ?


Check the postage in batches .

EXCEL What's the order of learning ?


3、 ... and : High order operation

High level operation is not used in daily work for most people . For those who want to master excel For people who , This stage is essential .

About the higher order operation part , It's about learning macros and VBA Knowledge , among VBA Some of the content of programming involves , Therefore, there is still a certain degree of difficulty for students who have no programming basis , It takes time to learn . But the macro is still very easy to master ,「 If you have a lot of repetitive work in your job , I strongly recommend that you learn how to use macros 」, It's guaranteed to increase your productivity several times , Save a lot of time for your leisure time .
版权声明
本文为[Changzhou SEO is]所创,转载请带上原文链接,感谢
https://fheadline.com/2020/11/202011252138109624.html
相似文章

2021-08-09