excel data

Given are the University list for which we need to find out the following:-

1) MBA COURCES OFFERED
(in each university we need to find out how many MBA courses they offer
example MBA in IT, Finance, management ect) NOTE only MBA

2) NUMBER OF CREDITS In
each MBA course how many credits they have if they listed it in their
website please try to find this out (Example economic 3 credits, info 3
credits and so on )

3) ELECTIVES In each MBA course how many elective courses they have only if it is available on the website

4) Name of the courses :- NAME OF THE COURCES WHICH ARE OFFERED