by admin | Jun 7, 2021 | Tracking Training Records in Excel
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...
by admin | Feb 8, 2021 | Tracking Training Records in Excel
A while back I had a message from a colleague. She had got a training contract but she wanted to track it on Excel. She needed to be able to see what days her courses were being delivered and by whom and the topic. She had made the – oh so common – mistake...
by admin | Nov 30, 2020 | Tracking Training Records in Excel
A while back one of my customers asked me about a way to create a unique ID from a customer’s name and a random number. Of course I was intrigued and using a combination of Left(), Right() and Randbetween() helped her do just that. Yum, I do love me an Excel...
by admin | Oct 12, 2020 | Tracking Training Records in Excel
Quite often I get people asking me how to do X or Y and this video addresses how Excel would be used to identify what is early, late and on time – assuming a 10 day buffer (either side). I am using this to experiment with the IFS function ( a new function in...
by admin | Jul 12, 2019 | Tracking Training Records in Excel
A follow up question I have received a lot is about what to do if you have once off records, expired records etc. So in this video I have addressed this issue. There’s a quick revision of how you use the vlookup() function to calculate expiry dates but the main...
by admin | Apr 16, 2019 | Tracking Training Records in Excel
A question I get asked a lot on this website is about how to create expiry dates for different courses in Excel. So here is a video that shows you how to do it. It does require that you have a list of courses with their duration in days e.g. a course...
