Employee basic information registration form

Employee basic information registration formIt refers to the documents and materials used by the enterprise to record the personal experiences, political thoughts, business technical level, work performance and job changes of employees. The free download of the employee basic information registration form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more free downloads of the employee basic information registration form, please pay attention to Huajun Software Park.

Introduction to employee basic information registration form       Employee basic information registration formprocess:      
a. Understand the basic situation of the employees;
b. Employee promotion and demotion;
c. Employee rewards and punishments;
d. Employee transfer.

General tips for employee basic information registration form

   1. Sum: =SUM(K2:K56) Sum the area from K2 to K56;
​ ​ 2. Average: =AVERAGE(K2:K56) Find the average of the area K2 K56;
3. Ranking: =RANK(K2,K$2:KS56) ranks the results of 55 students;
​​ 4. Level: =IF(K2>=85, "Excellent", IF(K2>=74, "People", IF(K2>=60, "Pass", "Fail")))
5. Semester overall evaluation: =K2*0.3+M2*0.3+N2*0.4 Assume that column K, column M and column N respectively store the three grades of students: "usual overall evaluation", "midterm" and "final";
​ ​ 6. Highest score: =MAX(K2:K56) Find the highest score in the K2 to K56 area (55 students);
​ ​ 7. Minimum score: =MIN(K2:K56) ——- Find the lowest score in the K2 to K56 area (55 students);

Recommended by the editor of Huajun Software Park