They did for me! It was quick and easy! Additional Employee Absence Data Try entering a few of the absence days to see if the new custom days work. See Figure 6.Īll of the changes that you make are automatically populated onto the other worksheets, just as the instructions indicated. Add the letter “J” in the color box for Custom 1 and “B” in the color box for Custom 2. Just click on the cell that had the Custom 1 text in it and typed in our new text. Let’s say you want to add in Jury Duty as the Custom 1 color and Bereavement as the Custom 2 color. To customize the colors or types of absence days, there are also great instructions. See Figure 4.įigure 4 Customize Employee Absence Color Coding See Figure 3 to see where the new blank row was added under Employee 5.Īfter adding employee names, the sample absence data could be cleared out by selecting the cells for the five sample employees and hitting delete. The template had 5 employees listed but all you have to do is click on the last cell for the last employee and hit the Tab key. After entering the year, you can read the instructions on the template to help add new employees. It is very easy to get started with the template. It will automatically be updated for the other month’s pages. It is over on the right side of the screenshot. You just have to enter the year in cell AG2. Download the Employee Absence Templateĭownload your employee absence schedule here.įigure 1 shows the first page of the template. I’m really amazed at what you can do without having to “re-invent the wheel” and start your spreadsheet from scratch. The templates have come a long way over the past few versions of the application. If you have not explored the templates in Excel, then you are missing out. This Excel template is free and doesn’t need to be integrated with another program. Specialized HR programs can be expensive. Lists and databases can be hard to follow and cumbersome. I have seen numerous spreadsheets created in-house that got the job done but were not visually easy to read. Trying to set up and track all employee absences can be difficult. It makes recording and tracking a breeze! If you are a small business, this is a must-have to help your business run more efficiently. Are you tracking employee absences in a regular spreadsheet or on paper? If so, you want to know about a great Excel template that will help you organize and track employee vacations, sick days, etc.

Pto schedule excel template