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

Qn.A

I have create a table and made alignment.

Qn.B

I made summary of Products Sales in new worksheet by using excel functions

Qn.C

I made pivot table and chart for the categorical data

Qn.D

Through Excel options, I made customise ribbon name ABC

Qn.E

By using pivot table, Quantites ordered for each country is calculated

Qn.F

By using conditional formatting>>text that contains, clours have given to column status and productline

Qn.G

By using text to columns in the data tab, I made date format and through replace I replaced all values

Qn.H

Using sumIf function, I calculate the value in new worksheet

Qn.I

Using left function and Replace function, I split the text and made two new columns

Qn.J

By using conditional formatting, highlight top 10% for the column Qunatity ordered.