Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

We done the project on Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

We used the formulas for finding the calculation of summary of Products Sales

Analyse the sales happened by product line & status using pivot table

Customized Tab

Analyse the Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table

using conditional formatting we recreate the structure of table using different color

also change the formatting using functions and split the column

Calculate the total sales using pivot data

Highlight the top 10% values of QuantityOrdered field using Conditional Formatting