could you please solve to me the 3rd question please ?

I need the steps for doing it on Excel

A training center wants to follow the diffesent types of training it offers. For this purpose, it decided to design a dashboard allowing it to visualize the follow 1. Training type according to the Number of Training sold with il possibility to select them accotding to the year (Use a ulicer) 4 Marks 2x Training type according to Sale values (Sales) The proposed chart nust offer the possibility of selection by, Year (use the prewious sticer) 4 Marki 3. The number of tralining sold by yeari. 3 Marks 4. Mbar chart hhowing sum of sales by year. This chait and the just previous one can be selected topether by training Name. (use a slicer) 4 Mark 036 A training center wants to follow the diffesent types of training it offers. For this purpose, it decided to design a dashboard allowing it to visualize the follow 1. Training type according to the Number of Training sold with il possibility to select them accotding to the year (Use a ulicer) 4 Marks 2x Training type according to Sale values (Sales) The proposed chart nust offer the possibility of selection by, Year (use the prewious sticer) 4 Marki 3. The number of tralining sold by yeari. 3 Marks 4. Mbar chart hhowing sum of sales by year. This chait and the just previous one can be selected topether by training Name. (use a slicer) 4 Mark 036