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

a. Proper formating has been done in sales_data sheet of the workbook.

b. All the ask has been calculted at bottom of the sales_data sheet of the workbook.

c. The pivot table have been created in question c sheet of the workbook.

d. The customized ribbon named ABC having the data formatting commands added in it is in sales_data sheet.

e. The pivot table have been created in question e sheet of the workbook.

f. The conditional formatting has been done in Question f sheet of the workbook.

g. The years have been replaced and the dates have been converted into a specific format.

h. The total sales have been found in sheet h of the workbook using pivot table.

i. The cloumn has been seperated in sheet i of the workbook.

j. The conditional formatting for 10% ordervalue has been done in Question j sheet of the workbook