Method of making attendance sheet

The production method of attendance sheet is as follows:

1, tool material: Chinese characters.

2. Create a new Excel worksheet-write the title on the first line.

3. Place the mouse in the first cell in the third row-Insert-(Illustration)-Shape-Find the diagonal line.

4. Click the icon-Format-Adjust the diagonal color.

5. Insert Text-Text Box-Draw a horizontal text box.

6. Write the date in the corresponding position.

7. Click Format-Shape Outline-No Outline (Image Fill-No Fill).

8. Place the mouse in the date text box-hold down the keyboard CTRL- move the text box to finish copying-change the text to the name.

9. Now write 1 2 in the second and third cells in the horizontal row-select two cells-move the mouse to the lower right corner to form a small plus sign-drag the mouse to the right-complete the date filling.

10, write your name in the corresponding position, and write Man Qin for a few days in the second line. Team, wait. Add the days of attendance, lateness, vacation and business trip at the end of the form.

1 1. Select the cells of attendance days, lateness days, vacation days and business trips-Start-Text Direction-Vertical Text, and select the first line title-Merge Cells.

12. Select all worksheets, double-click anywhere in the red box below, and set the most appropriate column width (text center, font, etc. Can be set together).

13, the bottom is marked with different codes according to different situations.

14. Select the time sheet in Drawing-Start-Border-Draw Border.

Brief introduction of attendance sheet

Attendance form is a form to record the attendance of employees, which is used to monitor and manage the time when employees go to work, get off work, ask for leave and work overtime. It can help enterprises accurately record employees' attendance and improve work efficiency and management level. Attendance Form Content Date: Record the attendance date every day. Employee's name: record the employee's name or job number for identification. Working hours: record the specific time for employees to go to work every day. Off-duty time: record the specific time when employees get off work every day.

With the progress of science and technology, many enterprises have adopted electronic attendance system to replace the traditional paper attendance sheet. Electronic attendance system usually records the attendance information of employees by swiping cards, fingerprint identification and face recognition, which is more convenient and efficient. Through the electronic attendance system, managers can monitor the attendance of employees in real time and reduce the complexity and mistakes of attendance work.