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