**Excel is a spreadsheet program that is part of the Microsoft Office suite. Exccel supports basic functions so that users can use this tool effectively and quickly. With the basic functions in Excel below such as Sum, Min, Max, … will be very helpful when you often have to work on Excel, especially in the field of accounting and HR. To better understand, please follow the article below of Taimienphi.vn!**

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

**Table of Contents:**

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.

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*

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

.