Add the title of the sheet as attendance for month january february or whatever the month is for which you are recording this information.

How to make an attendance tracker in excel.

You can also adjust your own attendance spread. Hello friends in this video you will learn how to create an attendance tracker. You can create an attendance tracker in excel easily. Emp name and supervisor name to be entered manually. You can create this attendance sheet in all version of excel and even you ca. Video 82 hire software experts to get customized attendance management software.

Add company logo as well to make the sheet more reliable and dependent for the staff members of your company. Attendance to be marked in date column. Create 12 sheets for every month in a workbook. Step 2 add format dates now it s time to add dates format them and remove weekends. Attendance in ms excel can be prepared in many different formats. If you plan to track attendance for a year you will need to create each month s sheet in excel.

Attendance tracker in excel. This video will show you how to create a simple excel spreadsheet to record and track your employee s attendance. In this tutorial you will learn how to make attendance sheet in excel. Fire up excel and start by adding labels for attendance and name then use student1 for the name name slot. Do not forget to mention the year as companies are having records up to 20 years of time. With the student1 box selected hit ctrl enter then drag down from the bottom right corner of the box to fill in more student slots.

Add columns for each date in each month s sheet. Present count absent count leave count unplanned and planned are calculated field. Please download this excel file from below given link.