Complex Employee Training Tracker

ASA_QA 

Reading your description makes me think that you may be pushing the boundaries of Excel here, that perhaps something like Access (or some other relational database software) might be more suited. That said, Excel IS very powerful, and with Power Query and other tools available, might well be able to handle the tasks you've laid out.

All of that having been said, is it at all possible for you to grant us access to the actual spreadsheet (with real names and any other identifiable or confidential information removed)? A mockup representing the actual could be an alternative. Post it on OneDrive or GoogleDrive or some comparable cloud service and grant access here.

Let us know too what version of Excel you're working with. I hope, for your sake, that it's the most current version. There are some very powerful functions that are relatively new. I've already referred to Power Query. Other newer features include FILTER, which could be of great help in what you're trying to do. Here's a video that explains it well. Armed with this tool you might be able to resolve many of your needs. https://www.youtube.com/watch?v=9I9DtFOVPIg

For what it's worth, I'm retired now, but when employed had experience with (a) responsibilities for management training and (b) for a few years, was director of a project to design a corporate HR and payroll database. So I have experience in working with the raw materials you're dealing with......