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

A. Formatting of the data has been done in each worksheet.

B. Solved in sheet "QB". Data was sourced from the sales data sheet into the formula directly.

C. Pivot table created in sheet "QC" using sales, product line, and status.

D. Custom tab ABC was created with new groups of commands. It can be viewed on the ribbon.

E. Pivot table created in sheet "QE" using quantity ordered, country ID, quarter ID, and year ID.

F. Conditional formatting applied to the Status and Product Line columns in the data set.

G. Values have been changed using the find and replace function.

H. Pivot table created in sheet "QH" using status and sum of sales.

I. New columns created in N and O and the data was entered using LEFT and RIGHT functions.

J. Top 10% highlighted in green.