Use the Excel2003 attendance record template to make an attendance sheet

So far, the unit attendance with attendance machine, punching machine, fingerprint identification equipment a lot. But there are still many units are still using paper to sign in attendance, the end of manual statistics. A little manual error always brings a lot of trouble. In this section, we do not consider the use of expensive attendance equipment, only with Excel2003 attendance record template to make an intelligent attendance sheet.

Perhaps you have wanted to use Excel to make a few functions to solve, but the cumbersome calculation formula may let you give up the idea, in fact, Excel2003 template has a good time sheet, you just spend five minutes to do a simple setup on the good.

Activate the Attendance table template

Activation is called here because it is not installed by default. So, you'd better get the Office 2003 CD ready, and then click on the "New" menu "new workbook → The template on this machine → electronic solution form → attendance record" and follow the on-screen prompts when it prompts you to insert the disc. Later, you'll see a nice time table interface.
Second, change the default settings

Since it's an electronic attendance book, then there are three points is the most important, one is automatic statistics, and second, outsiders can not be arbitrarily modified, the third is to enter the data can not be wrong, such as the loss of sick leave to 1, I am afraid who also do not understand what the meaning, and then we say that the three points.

1, Unlock the attendance table

The new attendance table default is lock state, in addition to input data, we will not be able to do anything, so first click on the "Tools" menu → "protection → remove worksheet protection" to unlock it.

2. Modify the allowable data

We require a number to represent the employee on a day off, with a null value for the day did not leave. So, to set each cell to accept only the number 1 or empty, characters other than these two values will prompt for an error.

Use the mouse to drag and choose all cells from January 1 to December 31, click on the "Data" menu → "effective", in the pop-up as shown in Figure 2 dialog box, the software default maximum "8" to "1", and then the "error warning" label in the "wrong message" also changed to the required content.

3. Re-add lock

The purpose of re-locking is to facilitate our daily use and protect the safety of the formula, because the table needs to set the cells have been preset, here simply click the "Tools" menu → "Protection → protection sheet" to complete the table lock work.

Tips: After the first open time after the lock will automatically stop in the "unit" in a grid, at this time, with the TAB key will be automatically in the need to enter the cell jump, easy to operate.

Third, the production of other staff attendance form

1, copy the attendance form

Everyone may find that the time sheet can only reflect the attendance of an employee, then how to reflect the data of other people? To do this, right click on the bottom "Sheet 1" tab and select "Move or copy sheet" to check "make a copy" in the pop-up dialog box.

2, rename the attendance table

To make it easier to find, we'll change the number of copies of our time sheet labels to the employee's name. Double-click the label name, and then enter the employee name.

Add the password for the attendance form

Since attendance records involve all aspects of the problem, we must ensure that other personnel can not modify or view the table. The method is to set the password to open and edit. Click on the "File" menu "Save as → tools → general Options", in the dialog box in Figure 4, set the "Open password" and "Edit password" entry to enter your password and then save the file.

Tip: "Open password" means that whenever the table is opened, the system prompts for a password, and when the password is incorrect, the contents of the table will not be visible. The meaning of "password to modify" means that no modification can be implemented without providing the correct password, but the table contents are visible directly

V. Summary

After a few steps, I believe you have produced a can help you to deal with the general attendance statistics of the table, if you are familiar with the use of Excel, you can also create a new summary table, and then automatically call the tables summarized data to achieve the row leave, the department attendance summary and other work, or directly to the performance evaluation formula into which, so that the computer directly generated monthly payroll.