Pivot tables are as intuitive and easy as they are powerful. The best way to learn is to play around with them. I'll get you started though...

In a new sheet...Insert Pivot Table
Enter the data range from Sheet 1
Press OK.
In the Pivot Table Field list, check Training Type and Training Start Date. They will appear as Row Labels.
Click and drag Name Surname to the Values Box. It will appear as Count of Name Surname.
Right click on any of the dates that now appear in the pivot table. Select Group. Highlight months and years. Click OK.