Need help with generating 3 reports from one file

Dear All,
Greetings! This is my first post here and I will admit am a total novice with excel as far as macro or vba and all the other high end stuff is concerned. Please take a look at the attached spreadsheet. I need help in generating the below 3 results/reports from the attached file. Would it be possible to run an exception report that would return the below three results/reports.

• An exception report that reflects those candidates that are missing training.
• An exception report to reflect those positions that are missing the mandatory training for the positions listed on the REQUIREMENTS tab. The REQUIREMENTS tab reflects the list of positions if mandatory training is required or not.
• Would it be possible to format the names in such a way so that the name turns red in colour a month before his training expires? The validity of the training is mentioned under the REQUIREMENTS tab against the names in the first row.

Any help will be greatly appreciated, thank you so very much.
Kind regards,

Jan