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