Checking if employees have completed trainings? Vlookup, countifs, ... ?

[begexcel]

Hello,

If someone can help me here, that would be really nice.
Background:
I am tracking people who have completed certain trainings, I get this data from database. Problem is that I need to manually check who has NOT done as data only contains people who have done training.

I have included an example document so you can get a better idea.

See below for comments per sheet:
Data Source: This data we get from our database. There is data only available for employee has tried to do test.
Staff: List of our employees
Courses: List of training courses

Since some courses are mandatory, I would need to know who hasn't done them yet.

Problem is some haven't even tried the test (missing from data) and some have tried, but have failed.

What would be the best solution to do this?

I would need to automate this to a list which I could pivot easily.

On tab "Manual" you see how it would be perfect but that is way too admin heavy as it is manual.

It would need to be dynamic and work in the future, when I add more courses to the list.

I've tried playing around with vlookup, countifs but I am currently stuck and can't think how could I achieve this.

Grateful for all the help!