This blog post shows you how to colour code your training records. It helps you identify who is current, who is due for renewal and who is overdue. It also allows for those once off courses – you know the ones that new staff have to complete but are only done once.  You can download the completed file here

I used the IFS() function – which is only available in later versions of Excel (2016 and later) because it is actually just easier to do a nested if with it.


If you track your training records in Excel you might be interested in my book on the very same topic – you can read more here.