Excel-project

Objectives The store owner wants to create an annual sales report for 2022. So that, He can understand customers and grow more sales in the future.
1 Compare the sales and orders using a single chart.
2 Which month got the highest sales and orders?
3 Who purchased more- men or women in 2022?
4 What are the different order statuses in 2022?
5 List the top 10 states contributing to the sales.
6 Relation between age and gender based on number of orders.
7 Which channel is contributing to maximum sales?
8 Highest selling category?

DATA CLEANING
Used find and replace function to replace M with Men and W as Women
Used find and replace to convert quantity mentioned in text to numeric form

DATA PROCESSING
Grouped age into groups using IF condition [=IF(E2>=50, "Senior", IF(E2>=30, "Adult", "Teenager"))] to analyze data in a better way.
To extract the month in text form from the date column use formula [ =TEXT(G2, "mmm")]

DATA ANALYSIS
Created pivot table and chart to analyze Order Vs Sales.
Used formula [0.00, "M"] to convert the format into a readable form.
Used pivot tables and charts to generate different insights.

Insights 1 During March both orders and sales are high.
2 Women contribute more (64%) in sales than men(36%).
3 Most of the items were delivered.
4 Top five states are Maharashtra, Karnataka, UP, Telangana, and Tamil Nadu.
5 Most of the orders are placed by women of the adult category.
6 Orders from Amazon contribute to the highest(35%).