How could I solve this problem and what formula's could I do in Excel? An example of the data will be attached.

Bruce Tucker, your boss, sends you this file and gives you the following information. He says he wants your analysis when he returns next week.

$$Once you organize this data set. I need you to analyze the $18-19$ academic year $($summer$,$ fall, winter, spring$)$ enrollment by course and term. I am giving a presentation to the new Provost in an attempt to convince her to invest more money in the undergraduate business program because we are growing both online and on campus. I think the following stats will be convincing:

What is the ratio of ground campus classes versus online courses?

By concentration and BA core

Make a pivot table to show this info