could you please solve to me the 1st question please ?

I need the steps for doing it on Excel

A training center wants to follow the different types of training it offers. For this purpose, it decided to design a dashboard allowing it to visualire the fo 1. Training type according to the Number of Training sold with a possibilify to select thein according to the year (Use a slicer) 4 Marks. 2 Training type accordinge to Sale values (Sales). The proposed chart must offer the possibility of selection by year (use the previous slicer) 4 Marka 3. The number of waining sold by year. 3 Marks 4. A bar chart thowing sum of sales by year. This chart and the just previous one can be selected together by training Name: (use a slicet) 4 . Marka