In this tutorial I am going to show you how to set up a database that allows you to track mandatory training.
If you want to download the completed file – you can download it here
Step One
Set up your database with name, course name, start date of course. We will set up a data validation list to create a dropdown for the courses. This is the setup file
Step Two
We will be using formulas to identify when the course is due for renewal, then another formula to set its status. This is the file with the formulas.
Step Three
Conditional formatting to identify who is due. This is the completed file again.