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

Q No a, b,d,f,g,j are answered in main sale data worksheet only.

Q No C & H is in one sheet only.(pivot)
Q No E is in different sheet. (pivot)

Note: Q No i. i do not have the microsoft 365 version to use Text function i.e.
TEXTBEFORE,TEXTAFTER functions to split the column @PRODUCTCODE.

I performed same by using LEFT & RIGHT functions. please consider it.