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

a. Answer submitted in separate excel sheet.

b. Answers wrote at bottom side of sales tab i.e., in E2829 and submitted #not included last column in sales tab i.e.,E2825 becaues it was formula . This is applicable for all answers.

c. Answer submitted in two methods in single sheet in various tabs by changing the columns and rows.

d. Answer submitted in Excel and screen shot attached just for reference.

e. Pivot submitted in two methods.

f. Updated conditional formatting for required sections.

g. converted all dates to required format

h. Submitted in Excel sheet in "h" tab and also submitted in sales sheet by using formula.

i. Separate tabs created in excel sheet in "i" tab.

j. Answered sunmitted in "j" tab in excel sheet.

Note: Answers from b to j all submitted in one excel