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

1.

a,b

1	tqtal sum of sales	10032644.9
2	average of sales	3553.89474
3	stanerdeviation of sales	1841.86036
4	variance of sales	3392449.6
5	maximum of sales	14082.8
6	minimum of sales	482.13

c. i am going to insert and then pivot table feild add to productline status and sum fo function

d. excel optiop is customized tab and creat new abc commends tab

e. i am going to insert and then pivot table feild add to sum of values quantities ordered and columns of year

row is country and qur_id

f. status and productline use conditional formatting in manege rules

g. that value is find and replace function enter values

h. pivot table will be add in sum of sales and then status product

i. i go to data tab in text to columns one click delimited and next space next add columns and finish

j. conditional formatting in top bottom ruls , top10% ok