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

a. Formatted

b. Summary of sales prepares

c. categorical representation is also performed on the data set

d. Customized ribbon ABC is also created

e. Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarter is also prepared

f. Conditional formatting was performed in the fields Status and ProductLine

g. Data has been cleaned with respect to proper date

h. Total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, and “Resolved” products

i. Two new fields have been added in the data sheet

j. The top 10% values of QuantityOrdered field have been highlighted