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 .
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 ：
「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 .
3.「ctrl+F」 Shortcut key , Quickly find and replace . For example, find out the wrong words and replace them .
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 .
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 .
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 ：
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 .
Here's another Fast sum Methods , Click the auto sum option at the start , The system will automatically use sum Summation of functions .
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 .
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 .
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 .
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 .
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 "-".
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 .
Check the postage in batches .
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 .