Excel data analysis common functions

2020-12-08 12:29:20

In data applications ,excel Is our most common data processing and presentation tool , Before that , We've learned about data processing and excel Shortcut key operation （ If necessary , You can refer to the previous article for learning ）, In learning Excel After the basic operation of , Will it be limited to just excel How about interface operation ？ Actually excel It also provides us with a wealth of functions . Function as Excel One of the most important means of processing data , The function is very powerful , In life and work practice can have a variety of applications . Next , Please start with the essayist Excel The journey of function . This paper mainly introduces some knowledge related to function .

1

Function definition

Excel The function in is a kind of formula , It's in excel Can be very convenient to deal with complex calculations , We are “ Parameters ” Only the necessary parameters need to be specified in the element , We can get the result of his calculation . If you don't use functions , You can't do complex calculations .

excel You can do all kinds of calculations in , Generally, several formulas are needed , To perform relatively complex calculations . Enter... At the beginning of the formula “=” Number , Then enter the function name , Add... After the function name () You can enter the function . Parameters are necessary for calculation and processing , The type and content vary from function to function . Select the cell where the formula is entered , The formula will appear in the edit bar , The result of the calculation is displayed in the cell .

The table structure of the function is as follows ：

2

Function steps

Input functions are used “ Insert the function ” There are two methods to input the formula directly in the dialog box .

When the order and content of parameters are not clear , Or when you don't know what function to use , Use “ Insert the function ” Dialog box method input function . here , It will automatically input the “,” And double quoted text .

If it's a frequently used function , Generally, you can remember the order of parameters and the method of assignment , So it's more convenient to input directly in the cell . however , It and the use of “ Insert the function ” It's not the same , Therefore, we must be careful not to leave out the semicolon or misspell the function name .

1、 Use “ Insert the function ” Dialog box .

1） When you don't know what function to use , You can click on the “ Common functions ” Drop down arrow at , And then choose “ All ”;

2） Can be in “ Selection function ” Choose the function of your choice , such as “sum” function . Click ok .

2、 Direct input function

1） Click the cell where you want to enter the function , Input function sum after , Add a bracket , The parameters that this function can add will appear later ;

2） You can enter the required parameters in the function , Click enter , The result of data calculation will appear .

3

Common functions in data analysis

excel There are many functions in , Including database functions 、 Date and time functions 、 Engineering functions 、 Financial function 、 Information functions 、 Logical functions 、 Query and reference functions 、 Mathematics and trigonometric functions 、 Statistical function 、 Text functions and user-defined functions .

And for data analysts , There are four types of functions in common use

1） Simple functions

2） Text functions

3） Logical functions

4） Find and reference functions

What functions do these functions contain ?

1、 Simple functions （ Including summation 、 Count 、 Average 、 The most value 、 The product of 、 Excepting 、 integer ）; 2、 Logical functions （ contain if、and、or); 3、 Text functions （ Contains text extraction 、 Text search 、 Text substitution 、 Text conversion and merging 、 Case substitution ）; 4、 Reference and lookup functions （vlookup、hlookup、lookup、indirect、index、match)

4

Summary

This paper sorts out the definition of function 、 The use of functions and the classification of functions , Readers who have already used functions can skip this article , Next , We will focus on the use scenarios and cases of four types of functions . Coming soon ！

The source and reprint of the original text are detailed in the text , If there is any infringement , Please contact the yunjia_community@tencent.com Delete .

Original publication time ： 2020-11-26

Participation of this paper Tencent cloud media sharing plan , You are welcome to join us , share .

https://chowdera.com/2020/12/202012081228328313.html