Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
ABC NewTab and Add formating from the customize ribbens
Clean the Data with respect to date by proper date formatting and change values of 2003 to 2019, 2004 to 2020 and 2005 to 2021.
Make summary of Products Sales by providing
- Total Sum of Sales
- Average of Sales
- Standard Deviation of Sales
- Variance of Sales
- Maximum Sales
- Minimum Sales
| Sum | 10032659.9 |
| Avg | 3553.90005 |
| Max | 14082.8 |
| Min | 482.13 |
| Std | 1841.85592 |
| Var | 3392433.21 |