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

a) I have done the alignment, Added borders and set the entire data in the middle of the cells by merge and centre.

b) I have done all the required problems in the excel sheet. Please find Attachment.

c) Analysed the sales happened by product line & status using pivot table. PFA.

d) I ahve created a customised ribbon and added it as a new tab named ABC.

e) Please see attachment

f) I have done the conditional formatting to all the required areas for status and Product Line. Please see the attachment.

g)Changed the dates of 2003,2004,2005 to 2019,2020,2021 by using find and replace.

h) Done it using pivot table.

i) I have done split cells by using text to columns command.

j) Done through conditional formatting by selecting top 10%.