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

b)

c)Analyse the sales happened by product line & status using pivot table

d)Make Customized Tab by naming ABC and keep few data formatting commands in the newly created Tab.

h) Calculate the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products.