Microsoft has created Excel office software with calculation functions that bring many convenience to users. When using Excel, you also need to specify some basic functions to serve your work without spending too much time for statistics and calculations. Taimienphi will guide you some basic functions in excel and illustrative examples for you learn excel track facilities.
Basic functions in Excel 2016, 2013, 2010, 2007
1. SUM Sum function: The function adds values to cells.
2. IF conditional function.
3. The function takes the left character (LEFT).
4. Get the character on the right (RIGHT).
5. MIN function: The function finds the minimum value.
6. MAX function: The function finds the maximum value.
7. AVERAGE average value function.
8. The function cuts TRIM spaces.
9. CONCATENATE string concatenation function.
10. COUNT function: The function to count numeric data.
11. COUNTA function: The function counts cells that contain data.
12. The function counts the length of a string.
13. The function displays the current time on the NOW system.
14. SUMIF function: The function sums conditional cells.
15. COUNTIF function: The function to count data conditionally.
16. COUNTBLANK function: The function counts empty data.
Basic functions in Excel and examples
1. SUM Sum function: The function adds values to cells
The SUM function is one of the basic functions in excel that allows you to sum values in selected cells.
Syntax: = SUM (Number1, Number2 ..)
Example: You need to calculate the total of 3 subjects of a male classmate.
2. IF conditional function
When you want to filter the values in an Excel worksheet, this time the IF function will help you do that
Syntax: IF (condition, value 1, value 2)
For example: To see who passed, to retake, you use the IF function with the formula = IF (H5> 5, “Do”, “Retake”). Type the correct formula, the results will display your request
3. The function takes the left character (LEFT)
The LEFT function is a function that takes the value string to the left of a string, you can get 2 or 3 characters in that character.
Syntax: = LEFT (text, n)
In which: – text: Character string.
– n: Number of characters to cut from the string. (the default value is 1).
For example: You want to get the first 2 characters in Student’s first name, you use the left syntax function as follows: = LEFT (B5,2) The result will return the first 2 characters exactly as shown below.
4. Get the character on the right (RIGHT)
Contrary to LEFT, RIGHT helps you get the right value of a string, and you can get more than 1 of them.
Syntax: = RIGHT (text, n)
– In which: – Text: string.
– n: Number of characters to cut from the string. (default value is 1)
Example: You want to get 2 characters to the right in Student’s first name, you use the following syntax: = RIGHT (B5,2) The result will return the first 2 characters exactly as shown below
5. MIN function: The function finds the minimum value
The MIN function finds the smallest value in selected cells or ranges
Syntax: = MIN (Numeric data container)
For example: Find the lowest grade point average of students in class
6. MAX function: The function finds the maximum value
The MAX function finds the largest value in selected cells or ranges
Syntax: = MAX (Container of numeric data)
Example: Find the highest total score of all students in the class
7. AVERAGE average value function
The AVERAGE function is one of the basic functions in excel that allows you to calculate the average value of selected cells or ranges. Using the AVERAGE function you will make the calculation simpler
Syntax: = AVERAGE (Number1, Number2 ..)
For example: You need to calculate the grade point average of a classmate
8. The function cuts TRIM spaces
The TRIM function eliminates spaces between characters in a string and leaves only a space (by a space between words). For many cells that contain a string with lots of spaces, the TRIM function is really helpful
Syntax: = TRIM (text)
In which: Text is presentable text contains spaces that need to be removed is 1
For example: In the Name column, there are currently a lot of spaces, to eliminate these spaces, use the syntax = TRIM (B5). The result will be as shown below
9. CONCATENATE string concatenation function
The CONCATENATE function is a string concatenation function in excel spreadsheets, used CONCATENATE function, you won’t have to manually put together the word sequences.
Syntax: = CONCATENATE (text 1, text 2, …)
In which: Text 1: is the 1st string (this is the required string)
Text 2 …: optional, up to 255 strings, and the strings must be separated by commas
For example: You want to note how much the student has overall. You use the syntax = CONCATENATE (B5, “whose overall score is”, G5). Then view the results, use your mouse to point to I5 and scroll down, the results will automatically be written
10. COUNT function: The function to count numeric data
The COUNT function is a basic excel function with data counting functions. Use Count function, you will count numeric data in an excel spreadsheet
Syntax: = COUNT (Container for data to count)
11. COUNTA function: The function counts cells that contain data
The COUNTA function has a function for counting cells that contain data
Syntax: = COUNTA (Data container to be counted)
12. The function counts the length of a string
The LEN function, a string length counter, works for you. The LEN function will return the value of the length of the string, including spaces
Syntax: = LEN (text)
In which: Text: is a string of characters
For example: If you want to count the number of characters in cell B1. You use the syntax = LEN (B5). The result will be as shown. To count the next cells, just hold the mouse at I5 and scroll down
13. The function displays the current time on the NOW system
The NOW function returns the current date on the system
Syntax: = NOW ()
For example:
14. SUMIF function: The function sums conditional cells
The SUMIF function is the basic function in excel that allows you to sum cells or ranges whose values meet the conditions specified.
Syntax: = SUMIF (Range, Criteria, Sum_range) Range:
Cells containing the Criteria condition: Sum_range condition: The cells to sum
For example: You need to calculate the total math score of the male friends in the score list
15. COUNTIF function: The function to count data conditionally
The COUNTIF function has a function for counting cells that meet the condition
Syntax: = COUNTIF (Container for data to count, condition)
For example: You need to count cells that meet the value = 6 in the Van column
16. COUNTBLANK function: The function counts empty data
The COUNTBLANK function is a basic excel function that counts the number of cells without values
Syntax: = COUNTBLANK (The data container to be counted)
When working with Excel, you need to understand the basic functions in Excel to be able to use Excel most effectively and quickly. Excel functions commonly used in basic office such as Sum, Min, Max … greatly support your study and work.
Above are some of the basic functions in excel. Excel is an office software that supports calculation very handy and popular, you can refer to the Excel keyboard shortcuts The most common way to manipulate software is faster.
https://thuthuat.taimienphi.vn/ham-co-ban-trong-excel-13238n.aspx
In addition to the basic functions in Excel, readers should also refer to advanced functions such as VLOOKUP, CHOOSE … to improve their knowledge, Advanced functions in Excel is applied to make operations faster on Excel spreadsheets.
.