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
Employee basic information registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Marketing Expenses Details,List of approved projectsDownload to get the source file, which you can edit, modify and replace. Download the basic employee information registration form and go to Huajun Software Park.




















Useful
Useful
Useful