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

a. I do the data formatting by applying allignment , font , colors, borders,converted data into tables .

b. in sheet i made a summary .

c. in excel sheet.

d. i attached the screenshot of custamise ribbon ABS IN EXCEL SHEET .

e. i made a pivot table according to the given data (in sheet).

f. i applied conditional formatting by different colors in field status and product line .

g. in sheet, i made a column date formatting column by converting text to date value and then replace it.

h. in sheet

i. i split two columns naming LEFT and RIGHT .

J. i APPLIED this conditional formatting in quantity ordered of top 10% values quantity ordered .