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

The Business Analyst for Company ABC Private Limited is required to perform various tasks on the provided dataset, which includes proper formatting of data, creating a summary of product sales, categorically representing the table using Pivot Table, creating a customized Ribbon, analyzing quantities ordered by each country in different quarters, presenting data in different colors using conditional formatting, cleaning the data with respect to date, calculating total sales of products, adding new fields to the data sheet using text functions, and highlighting the top 10% values of the QuantityOrdered field using Conditional Formatting. These tasks aim to analyze the sales data of different products, provide valuable insights, and aid in informed decision-making.