Make Attendance Sheet in Excel
Learn to take attendance in Excel in just 3 minutes flat or go to this link below to download the Attendance sheet Template in Excel for free.
In this attendance sheet video, you will be learn how to make the attendance of employees during a month . Yo could mark them as
- Present
- Absent
- Leave
- Half Day
- Holiday
You can mark people’s Attendance in office in Excel with formula and maintain absents, presents , leaves , halfdays on the excel sheet.
This way your daily attendance sheet would be ready and at the same time the monthly attendance for the office would also be ready in Excel for you to use with no extra effort.
How I made this Attendance sheet in Excel with Formula
To make this attendance sheet i have used the following formula in Excel
- Sum Formula
- Countif Formula
- Countblank Formula
To give the attendance sheet a great look, i have a used formatting tools in Excel like
- Font Size
- Font Color
- Cell Background Color
- Cell Styles
- Freeze Panes
Now an attendance sheet in excel for office should also show some analytics so i have shown the actual percentages of Present, Absent and Leaves. .
Click here for employee attendance sheet in excel free download