Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

Find the attachment.

Note : Not using offfice 365 so for question i , used left and right functions which is also a text function, instead of textbefore and textafter function which is advanced function.