Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
a. updated in exel sheet Named as Data Sheet
b.
| Total Sum of Sales | 10032628.9 |
| Average of Sales | 3553.88907 |
| Standard Deviation of Sales | 1841.86511 |
| Variance of Sales | 3392467.07 |
| Maximum Sales | 14082.8 |
| Minimum Sales | 482.13 |
c. PIVOT TABLE Named as Sheet 1 in exel sheet
d. ABC ribbon created in exel sheet
e.PIVOT TABLE Named as Sheet 2 in exel sheet
f. Updated conditional formatting.
g.updated in data sheet
h.PIVOT TABLE Named as Sheet 3 in exel sheet
i.updated in data sheet
j.Updated in exel sheet