Skip to content
Home ยป Free Online Automated Attendance Tracker Template in Google Sheets | Online Attendance Register

Free Online Automated Attendance Tracker Template in Google Sheets | Online Attendance Register

    In this Google Sheets video tutorial I demonstrate how to use and improve Google Sheets free online attendance tracker template. The Google Sheets attendance tracker template is pretty good out of the box but there are significant improvements that can be made.

    The improvements I make to the template are:

    • I automate the dates that appear in the tracker so that they automatically exclude non-working days and holidays (including school holidays).
    • I apply conditional formatting to the tracker to make it easier to read
    • I Include a count of days attended (for some reason not included in the original template)

    5 FREE EXCEL TEMPLATES
    Plus Get 30% off any Purchase in the Simple Sheets Catalogue!

    Click here to download the featured file.

    Video Table of Contents

    00:00 – Introduction

    00:05 – Open the attendance sheet template

    00:24 – Change dates to working days: Monday to Friday

    01:39 – Exclude holiday dates

    03:53 – Create a Tuesday & Wednesday class (exclude all other days)

    05:48 – Extend the date range of the attendance sheet

    06:38 – Understand how the ‘attendance key’ sheet links to the ‘classroom’ sheet

    07:55 – Add a calculation for the number of days attended

    09:38 – Colour code attendance and absence using conditional formatting