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

 a,  Appiled borders , Font size,Background colour,bold style to the given dataset.

b, Summerized the sales ,performed SUM(),AVERAGE(),MAX(),MIN() , STDEV.P(),VAR.P() of sale.

c, Analysed the productline & status using pivot table

d, Added a new tab (ABC) in the tabs menu,Added some formatting options in the ribbion.

e, Analysed quantities ordered by each country on yearly bases using pivot table.

f, By using conditional formatting highlighted the values 

g,Chaged the years 

h,Calculated the total sales by using pivot table.

i,Splited the columns using LEFT(),RIGHT() functions.

j,Highlighted the top 10% values of qunatity ordered using conditional formatting.