Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
A) PFA
B)
| Summary Of Sales | Total |
| Total Sum of Sales | 10032628.85 |
| Average Sales | 3553.889072 |
| Standard Deviation Of Sales | 1841.865106 |
| Variance of Sales | 3392467.068 |
| Maximum Sales | 14082.8 |
| Minimum Sales | 482.13 |
C) PFA
D) PFA
E) PFA
F) PFA
G) PFA
H) Mentioned in excel file
| Status | Total Sales |
| Shipped | 9288662.08 |
| Cancelled | 194487.48 |
| Disputed | 72212.86 |
| In Process | 144729.96 |
| On Hold | 178979.19 |
| Resolved | 150718.28 |
I) PFA - Mentioned twice
J) PFA