Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
b)
| i. Total Sum of Sales | 10032628.9 |
| ii. Average of Sales | 3553.88907 |
| iii. Standard Deviation of Sales | 1841.53885 |
| iv. Variance of Sales | 3391265.34 |
| v. Maximum Sales | 14082.8 |
| vi. Minimum Sales | 482.13 |
c) Added in new Sheet
d) Added customization in the ribbon
e) Analysed with pivot table in sheet 1
f) conditional formatting is given in the respected tab.