How to Create a Simple Excel Employee Attendance Tracker Spreadsheet

This video will show you how to create a simple excel spreadsheet to record and track your employee's attendance. You can also adjust your own attendance spreadsheet to meet the format in this tutorial to ease you calculating your employee's workdays.

I separated this video into 2 parts where you might need the second part if you want to count the number of working within particular month using a simple excel built-in function.

In this first part you can follow steps that are divided into 7 modules.
#1 Create attendance table
#2 Create absence code columns
#3 Create attendance date columns
#4 Fill absence code with similar format
#5 Create formula to sum similar absence codes for particular employees
#6 Duplicate the formula to other absence codes
#7 Modify absence code format to other format