Store marketing campaign data is used to create an excel dashboard and to use insights from it to identify the age group that maximizes the sales revenue.
-
Updated
Oct 27, 2023
Store marketing campaign data is used to create an excel dashboard and to use insights from it to identify the age group that maximizes the sales revenue.
Coffee Sales Insights - Excel Dashboard
This project is related to data cleaning and transformation
Coffee sales dashboard project made in Microsoft excel from scratch.
Integrated customer and product data in Excel's orders worksheet using INDEX, MATCH, and IF functions with absolute referencing. The project showcased adept Excel skills, featuring dynamic pivot tables and an interactive dashboard with timeline filters for insightful coffee sales analytics.
These files contain different uses of excel Formule and functions like statistical, logical, conditional, absolute reference, relative reference, Vlookup, Hlookup, Index_Match ETC.
This repository displays the work I have done on Microsoft Excel.
Add a description, image, and links to the index-match-function topic page so that developers can more easily learn about it.
To associate your repository with the index-match-function topic, visit your repo's landing page and select "manage topics."