Excel function for human resource management in business

Excel is an extremely powerful tool for calculating, processing and presenting spreadsheets. Currently, in all operations related to Human Resources: Recruitment, Administration, Salary C&B, Training… Excel is often used. Excel completely meets the above requirements, while helping users significantly reduce time, solving complex operations that are difficult for any program to compare with Excel. Therefore, many people feel like using Excel to manage human resources. Today ADSMO will introduce to you some Excel functions for human resource management.

1. LEFT function

• Syntax: LEFT(Text,n)

Text: is the original string;

n: Number of characters to cut;

• Use: Cut n characters from the left of a string

2. RIGHT function

• Syntax: RIGHT(Text,n)

Text: is the original string;

n: Number of characters to cut;

• Use: Cut n characters in the original string starting from the right

3. MID function

• Syntax: MID(Text, m, n)

Text: Text string;

m: position corresponding to the first character to be taken in Text;

n: Number of characters to cut;

• Use: Extract n characters from any position (m) in the text string

4. LEN function

• Syntax: LEN(Text)
• Use: Return the length of the character string;

5. TRIM function

•  Syntax: TRIM(Text);
• Use: Removes spaces in a string (leaving only one space between words)

6. SUM function

• Syntax: SUM(Number1, Number2,…)
• Use: Calculate the sum of a series of numbers;

7. SUMIF function

• Syntax: SUMIF(Series 01, Comparison condition, Series 02)

Series 01: Used to calculate the sum and compare with the comparison condition;

Series 02: Only numbers in series 02 are summed if the comparison condition between “Series 01 and Comparison condition” is satisfied;

• Use: Calculate the sum of a series of numbers according to a given condition;

8. AVERAGE function

• Syntax: AVERAGE(Number1, Number2,…)
• Use: Calculate the average of a series of numbers;

9. MAX function

• Syntax: MAX(Number1, Number2,…) 
• Uses:

Returns the largest value in the listed number sequence;

10. MIN function

• Syntax: MIN(Number1, Number2,…)
• Uses:

Returns the smallest number in the listed number sequence;

11. COUNT function

• Syntax: COUNT(Value1, Value2,…)
• Use: Count cells containing numbers in a table;

12. COUNTIF function

• Syntax: COUNTIF(Number range, logical condition)
• Use: Returns the number of cells containing values ​​that satisfy a certain logical condition;

13. MOD function

• Syntax: MOD(value1, value2)
• Use: Returns the remainder in the division of value1 by value2;

14. INT function

• Syntax: INT(decimal);
• Use: Returns the integer part of a decimal number;

15. ROUND rounding function

• Syntax: ROUND(Value 1, n)
• Use: Round decimal number Value1;

Note: if n>0 then round to the number n after the decimal point; If n< 0 then round to the number |n|+1 before the decimal point, the digits immediately following the |n|+1 digit before the decimal point are all converted to 0;

16. IF branching control function

• Syntax: IF(Logic_Test, Value1, Value2)
• Use: If the Logic_test expression is True, the IF statement returns the value Value1, otherwise it returns the value Value2;

17. VLOOKUP Search Function

• Syntax: VLOOKUP(Value1, Table_Array, Col_Index, Range_Lookup)

Value1: The value to look up;

Table_Array: The table of values ​​to look up;

Col_Index: The column number to get data from Table_Array;

Range_Lookup: The search range (1: Relative search; 0: Exact search correct);

• Use: Returns the value of a cell corresponding to the Col_Index column in the Table_Array table and the row corresponding to the Value01 value found in the Table_Array table;

18. TODAY() function

• Syntax: TODAY()
• Use: Returns the current system date and time;

19. NOW() function

• Syntax: NOW()
• Use: Returns the current system date and time;

20. DAY function

• Syntax: DAY(DateValue)
• Use: Returns the day status of a value of the date-month-year data type

21. MONTH function

• Syntax: MONTH(DateValue)
• Use: Returns the month corresponding to the value of the date-month-year format or the number of days in the year;

22. YEAR function

• Syntax: YEAR(DateValue)
• Use: Returns the year corresponding to the date data type;

23. WEEKDAY function

• Syntax: WEEKDAY(Datevalue)
• Use: Returns the day of the week corresponding to the date-month-year data type;

The function returns a value in the range from 1 to 7 (corresponding to Sunday to Saturday);

24. AND function

• Syntax: AND(Logic1, Logic2,…)
• Use: The function returns TRUE if the expressions Logic1, Logic1,… all return TRUE; The function returns FALSE when at least one Logic expression returns FALSE;

25. OR function

• Syntax: OR(Logic1, Logic2,…)
• Use: The function returns the value TRUE if one of the expressions Logic1, Logic1,… returns the value TRUE; The function returns the value FALSE when all the expressions Logic1, Logic2,… return the value FALSE;

26. NOT function

• Syntax: NOT(Logic)
• Use: The function returns the negation value of a logical expression;

Through the article Formulas for Excel functions for human resource management, ADSMO hopes that you will have more useful Excel functions for human resource management. However, instead of having to memorize all the above Excel functions, the HRM Plus human resource management software can solve all problems for each business. HRM Plus is built and programmed with great care and dedication, and is always the top priority choice of thousands of businesses today. HRM Plus human resource software possesses dozens of different diverse features to support all tasks in human resource management.

With time spent researching, testing and editing, HRM Plus has overcome most of the disadvantages of existing human resource management tracking software on the market as well as maximizing the strengths that a human resource management software should have. To experience the software HRM Plus right now, please contact ADSMO via Hotline: 0356.105.388 – a software that helps businesses optimize human resource processes, improve work performance and save costs.

>>>You may be interested in: Instructions for Creating a Salary Table in Excel and How to Use Common Functions