Forum Discussion
Complex Employee Training Tracker
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......
- ASA_QASep 06, 2022Copper Contributor
mathetes Thank you.
I had never paid any attention to Access, but you are right in suggesting that it may be a better fit for the information I'm trying to extract. I'm completely new to the program, so it'll take some time to figure out how to organize my data appropriately, but my hopes are high!
- caseysloanApr 22, 2025Copper Contributor
Hi ASA_QA did Access end up being your solution??