Using Data from Two Sheets to find classes

I work in a corporate job and somehow became the person on my team that knows excel best.

I’m okay with excel. Not an expert. But I need help.

I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available.

I also have a sheet of learner requests for classes.

I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes.

What’s the best method of going about that? Thanks.

If I need to go elsewhere to ask questions like this please direct me. Thanks.