The first step is to add the dates of a particular month to the Excel sheet. Select a cell and type the date with the format DD-MM-YYYY. For example, to create the attendance sheet for October ...

The beta version of Microsoft Excel supports a new checkbox feature that makes tracking data a breeze. A short Instagram video on the feature transformed how I track attendance for my sports team.