2, edit the title, indicate what this table is, generally write XX company x month employee payroll as shown in the figure.
3. Then we started to make the header. The header of general payroll will be divided into four parts: basic information of employees, basic salary, wages to be deducted, and finally calculated salary. Let's look at the basic information of employees first, as shown in the figure.
The following table shows the basic salary of the header.
5. Then, let's make the third part of the salary deduction as shown in the figure.
6. We continue to edit the fourth part, the salary accounting part, as shown in the figure below.
7. Finally, adjust the format. You can fill the header with color, change the title font, and then add a border to make a complete payroll.
How to make attendance sheet in excel 1 First, create a blank excel form, enter the content, and the attendance type can be defined by yourself.
2. Set the attendance type drop-down menu, click Data Verification, and then select Sort.
3. After setting the order, add employee names, such as dates.
4. According to the above steps, you can make the employee attendance sheet.
How to make company attendance sheet with EXCEL? The practice is as follows:
1. First, open an EXCEL blank form from the computer.
2. Enter the words "XX company Attendance Form" in any cell in the first row of the form.
3. Because the column width of the table is too large to hold too many words, adjust the column width first, click the format in the top menu bar, and then click the column width to adjust the column width from 8 to 4, so the column width becomes smaller.
4. Because the first column should write the names of all employees in the company, the first column is widened.
5. Enter 1, 2,3 from the second cell in the second line until 3 1, because there is only 3 1 day at most in a month.
6. On the right side of the cell of 3 1 day, write down the times of attendance, absence, business trip, sick leave and personal leave.
7. Write the names of all employees in the company from the first column of the third line. One person occupies a cell.
8. Finally, select the required parts under the first line, and then click the Tian Zi border button in the menu bar to add borders to these cells, and the company's attendance sheet will be completed.