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

A. Do proper formatting of the data with using borders, font size and appropriate alignment of the content.

> Used ALL Borders, 

> font size is 12,

>centre alignment.

B. Done all the summary of Products Sales.

C.The given Data for categorical representation of table based on fields Status, ProductLine and Sales using Pivot Table.

D. Customized Ribbon by naming ABC and keep all data formatting commands in the newly created Ribbon.

E. The Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table.

F.Given the data in different colours for values in field Status and ProductLine using conditional formatting.

G. Arrange the proper date formatting and change values of 2003 to 2019, 2004 to 2020 and 2005 to 2021.

H. calculated the all the sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products.in sheet H.

I. reference to Productcode using text functions
S10_1678 to be split as by using left formula S10 in one column and by using right formula 1678 in another column. given column refrence as product code.

J.Highlight the quantityordered filed using 10% value by using conditional formatting.