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

✅ Summary of Actions:

a. Data Formatting

• Apply borders

• Font size: 11 or 12

• Center alignment

b. Summary Statistics for Product Sales

• Total, Average, Std Dev, Variance, Max, Min of SALES

c. Pivot Table: ProductLine vs Status

d. Add Custom Tab Named "ABC" with common formatting tools

(Will be simulated by creating a separate sheet named ABC_CustomTab for demo purposes)

e. Pivot Table: Quantities ordered by Country in 2019, 2020, 2021 across Quarters

f. Conditional Formatting

• Color-coded by STATUS and PRODUCTLINE

g. Change Year values

• Replace 2003 → 2019, 2004 → 2020, 2005 → 2021 using Excel-friendly date replacement

h. Calculate total sales for selected statuses

(Using SUMIF)

i. Split PRODUCTCODE

• Create new columns: Product_Prefix, Product_ID

j. Highlight Top 10% of QUANTITYORDERED

• Conditional formatting