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

1. a. borders,font size and aligment are represented in the sheet 1.(a)

b. total sum of sales = 10032628.85

average of sales= 3553.889072

standard deviation of sales = 1841.538852

variance of sales =3391265.344

maximum of sales =14082.8

minimum of sales =482.13 are the values are represented in the sheet 1.(b)

c. field status ,product line and sales using pivot table are represented in the sheet 1.(c) & 1.(c.1)

d. as the customized ribbon is named as ABC and the all data formating commands are used in the customized ribbon of the sheet 1

e.as the quantities ordered by each country in year 2019,2020 & 2021 are using pivot table are represented in the sheet 1.(e) & 1.(e.1)

f.as the data are used for the values in the field status and product lines using conditional formatting are represented in the sheet 1.(f) & 1.(f.1)

g.as the data by propere date formatting changes values of 2003 to 2019, 2004 to 2020 and 2005 to 2021 1.(g)

h. total sales of all shipped products =9291501.08

total sales of all cancelled products=194487.48

total sales of all disputed products = 72212.86

total sales of all inprocess products =144729.96

total sales of all on hold products =178979.19

total sales of the resolved products =150718.28 are the values are represented in the sheet 1.(h) & 1(h.1)

i. as the new fields in the data sheet of the product code are represented in the sheet1.(i)

j. as the highlight the top 10% values of quantity ordered field using conditional formattion are represnted in the sheet1(j)