How to calculate the best and worst student in Excel from a list?

Question

excel

A list of students is given, in each line a class, full name, subject, grade. Several thousand lines. It is necessary to deduce - who is the best in grades, who is the best among the classes, among his class, who is the best in geography, etc. Well, who's the worst? How to do it ?
Or tell a freelancer who will do it for $.

Answer 1

This can be done using pivot tables.
If you send the file to the mail, I can make an example.

Answer 2

The fastest way is to copy it to Google Sheets and use SQL (QUERY function) there.
But you need to know SQL.
Though... show me who doesn't know him in 2019. Ask high school students, even they might know.
Well, or in the old fashioned way, master the VLOOKUP function and make the chain of formulas you need yourself.