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

ABC Private Limited manufactures and sells multiple product lines, including Classic Cars, Motorcycles, Planes, Ships, Trains, Trucks & Buses, and Vintage Cars. The objective of this analysis is to format sales data, generate key insights, and apply advanced Excel functions to support business decisions.

1. Summarizing Sales (Total, Average, Variance, Standard Deviation, Max, Min).
2. Analyzing sales performance by Product Line and Status using Pivot Tables.
3. Tracking order quantities by Country and Year (2019, 2020, 2021).
4. Applying Conditional Formatting to highlight important trends.
5. Splitting product codes for better categorization.
6. Updating Order Dates to align with recent years.
7. Calculating total sales for different status categories (Shipped, Cancelled, Disputed, etc.).
8. Identifying top 10% of Quantity Ordered using Conditional Formatting.
   

Note: I have taken my own dataset to render the output for the challenge presented as their isnt any enclosure or attachment available to the challenge. I have raised ticket but its going late so kindly consider the answer.