This project involves creating a Sales MIS report in Excel. It includes data cleaning, building pivot tables, and using VLOOKUPs to analyze sales by salesman, yearly trends, and profits. The report provides a clear view of sales performance and helps in tracking individual contributions.
E-Commerce Sales Dashboard - Excel This project involves creating an Excel dashboard to analyze e-commerce sales data. The dashboard allows users to select a product category and view sales trends by month and product. The analysis includes creating a histogram for shipping days, preparing sales and profit tables, and generating charts.
This repository contains an in-depth analysis of coffee shop sales data using Excel. The project includes data cleaning, exploration, and visualization techniques to identify trends, forecast sales, and improve business strategies. Key features include VLOOKUP, pivot tables, and advanced Excel formulas tailored for sales analysis
Add a description, image, and links to the data-analysis-in-excel topic page so that developers can more easily learn about it.
To associate your repository with the data-analysis-in-excel topic, visit your repo's landing page and select "manage topics."