Attendance Tracker (Excel)

Take the register. Excel does the maths.

A colour-coded register for 12 months and up to 40 people. Attendance % is worked out for everyone, and anyone below your target turns red. No macros.

WHAT IT DOES

• 12 monthly registers for up to 40 people

• 8 colour-coded codes you can set up: Present, Late, Half day, Absent, Sick, Excused and your own

• Choose what each code counts as, and leave excused days out of the %

• Attendance % for every person, every month

• Your own target, with red and amber warnings

• Year summary with absences and lates

• Dashboard: this year, this month, below target, lowest attendance and a month-by-month chart

• Weekends shaded and today highlighted

• Start Here guide and an example register

WHO IT'S FOR

Teachers and tutors, managers and HR, clubs, teams and groups.

GOOD TO KNOW

• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac

• Normal .xlsx file: no macros to enable

• One-off payment, instant download

Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.