How to use Excel to create a personnel and salary management system

1. Open a blank Excel sheet, name sheet1 as employee information table - merge A1:G1 and center, enter: employee information table - enter number, name, education, gender, age, department, A2:G2 respectively. Position – Then enter the relevant content for each column.

2. Make employee attendance sheets. Double-click sheet2 and rename it to employee attendance sheet - select A1:F1 - select merge and center, enter employee attendance sheet - enter number, name, lateness, personal leave, sick leave, and overtime in A2:F2 respectively.

3. Continue to prepare the employee sales performance table according to the above operations (the main column contents are number, name, and sales amount) - the main column contents of the salary table are number, name, basic Salary, attendance, bonus, total - salary slip table (mainly merge A1:F1, enter salary slips, no need to enter other items).

4. Create a user permission table, assign permission personnel to manage and edit the table, create a new table and name it user permission table - select A1:A3 to merge and center - enter user permissions - —A2:A3 enter the user name, user level and password respectively.

5. Make a salary description table to explain the calculation of specific work, the calculation method of basic salary in monthly salary, bonus and attendance reward and punishment methods, etc.

#6. After the table is created, press ALT F11 to open it at the same time, click Insert - Form to design the record form and enter it into the relevant table.

The above is the detailed content of How to use Excel to create a personnel and salary management system. For more information, please follow other related articles on the PHP Chinese website!