Human resource management mainly includes six modules: human resource planning, recruitment and allocation, training development and implementation, performance appraisal and implementation, salary and welfare management and labor relations management. The application of Excel function in human resource management is as follows:

1, human resource planning: Excel function can be used to find and reference data, for example, in a table of departments and employees, VLOOKUP function can be used to find the names and department numbers of employees, so as to carry out more effective management and planning.

2. Recruitment and configuration: Excel's IF function can be used to judge conditions, for example, when filtering and viewing recruitment information, use the IF function to filter and display relevant information according to conditions.

3. Training development and implementation: You can use the search function of Excel to find and quote data, for example, in a training program and student table, you can use the search function to find the name and training program number of the students.

4. Performance evaluation and implementation: You can use the MID function of Excel to extract specific characters or information from strings. For example, when calculating an employee's performance score, you can use the MID function to extract relevant information from the employee's performance report.

5. Salary and benefits: Excel's ROUND function can be used to round numbers to specified digits. For example, when calculating employees' wages and benefits, use the Round function to keep the calculation result in an appropriate number of digits.

6. Labor relations management: Excel's VLOOKUP function can be used to find and reference data, for example, in an employee and department table, use VLOOKUP function to find employee's name and department number, so as to better manage and maintain employee relations.