Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
| Row Labels | Sum of SALES |
| Classic Cars | 3919615.66 |
| Motorcycles | 1166388.34 |
| Planes | 975003.57 |
| Ships | 714437.13 |
| Trains | 226243.47 |
| Trucks and Buses | 1127789.84 |
| Vintage Cars | 1903150.84 |
| (blank) | 9291501.08 |
| Grand Total | 19324129.93 |
| Row Labels | Average of SALES |
| Classic Cars | 4053.377104 |
| Motorcycles | 3523.831843 |
| Planes | 3186.286176 |
| Ships | 3053.150128 |
| Trains | 2938.226883 |
| Trucks and Buses | 3746.8101 |
| Vintage Cars | 3135.33911 |
| (blank) | 9291501.08 |
| Grand Total | 6842.822213 |
| Row Labels | StdDev of SALES |
| Classic Cars | 2050.694132 |
| Motorcycles | 1837.292757 |
| Planes | 1519.539168 |
| Ships | 1073.70515 |
| Trains | 1456.595976 |
| Trucks and Buses | 1671.719775 |
| Vintage Cars | 1787.56854 |
| (blank) | #DIV/0! |
| Grand Total | 174787.9532 |
| Row Labels | Var of SALES |
| Classic Cars | 4205346.422 |
| Motorcycles | 3375644.674 |
| Planes | 2308999.282 |
| Ships | 1152842.75 |
| Trains | 2121671.838 |
| Trucks and Buses | 2794647.005 |
| Vintage Cars | 3195401.284 |
| (blank) | #DIV/0! |
| Grand Total | 30550828596 |
| Row Labels | Max of SALES |
| Classic Cars | 12001 |
| Motorcycles | 11886.6 |
| Planes | 10066.6 |
| Ships | 6960.48 |
| Trains | 8977.05 |
| Trucks and Buses | 8844.12 |
| Vintage Cars | 14082.8 |
| (blank) | 9291501.08 |
| Grand Total | 9291501.08 |
| Row Labels | Sum of SALES |
| Classic Cars | 3919615.66 |
| Motorcycles | 1166388.34 |
| Planes | 975003.57 |
| Ships | 714437.13 |
| Trains | 226243.47 |
| Trucks and Buses | 1127789.84 |
| Vintage Cars | 1903150.84 |
| (blank) | 9291501.08 |
| Grand Total | 19324129.93 |
| Row Labels | Sum of SALES |
| Classic Cars | 3919615.66 |
| Cancelled | 59242.81 |
| Disputed | 26012.87 |
| In Process | 57760.66 |
| On Hold | 49039.65 |
| Resolved | 25799.34 |
| Shipped | 3701760.33 |
| Motorcycles | 1166388.34 |
| Disputed | 31821.9 |
| On Hold | 4992.61 |
| Shipped | 1129573.83 |
| Planes | 975003.57 |
| Cancelled | 35432.71 |
| Disputed | 3843.84 |
| On Hold | 34727.53 |
| Resolved | 34532.92 |
| Shipped | 866466.57 |
| Ships | 714437.13 |
| Cancelled | 56665.65 |
| Disputed | 3070.4 |
| On Hold | 23664.61 |
| Resolved | 39863.71 |
| Shipped | 591172.76 |
| Trains | 226243.47 |
| Cancelled | 5082.42 |
| On Hold | 5808.48 |
| Shipped | 215352.57 |
| Trucks and Buses | 1127789.84 |
| In Process | 43026.41 |
| On Hold | 20193.29 |
| Resolved | 20472.75 |
| Shipped | 1044097.39 |
| Vintage Cars | 1903150.84 |
| Cancelled | 38063.89 |
| Disputed | 7463.85 |
| In Process | 43942.89 |
| On Hold | 40553.02 |
| Resolved | 30049.56 |
| Shipped | 1743077.63 |
| (blank) | 9291501.08 |
| (blank) | 9291501.08 |
| Grand Total | 19324129.93 |