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

Aim : As Business Analyst of the Company, you are required to perform following mentioned tasks on the provided dataset.

Company ABC Private Limited company data was given to given data I have done proper formatting of the data with using borders, font size and appropriate alignment of the content. Calculate the total sale with the help of sumif formula also replace the date and given colour to the productline and status column by using conditional formating. also calculate the Total Sum of Sales, Average of Sales, Standard Deviation of Sales, Variance of Sales, Maximum Sales, Minimum Sales by using the sum, var, max, min, stdev formula. Also create the pivotable and charts for the for the Report on requirement of Team Hiring.