Untitled

(via https://www.youtube.com/watch?v=xX_N9bSmMmY) 

(via https://www.youtube.com/watch?v=8kZuIy9CVRs)

(via https://www.youtube.com/watch?v=7Iwx4AMdij8)

(via https://www.youtube.com/watch?v=cvRUuhR9iec)

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. .