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

Excel file will be attached,Every sheet will be allocated to the each question.Sheet number will be mentioned below

a . Sheet-1 (proper formatting of the data with using borders, font size and appropriate alignment has been done to the data)

b . Sheet-10(At the end of the column sheet those sum,avg,std dev,variance,max,min functions are done)(pls scroll down to get the required solution)

c . Sheet-2 (Data for categorical representation of table based on fields Status, ProductLine and Sales using Pivot Table has been done)

d . By seeing the excel file only,we can see ribbon named ABC with formatted commands

e . Sheet-4(Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table has been done)

f . Sheet-5(Presenting data in different colours for values in field Status and ProductLine using conditional formatting is done)

g . Sheet-6(change values of 2003 to 2019, 2004 to 2020 and 2005 to 2021 has been done)

h . Sheet-8( Total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products are done)

i . Sheet-7

j . sheet-3 only in the top,I have given the solution of 'j'

All sheets are given in the sequence in the uploaded excel file