Still loading…
Still loading…
An Excel dashboard for analyzing sales, revenue, costs, gross profit, and performance by product, region, and month.
Personal Portfolio Project · 2026
Project Overview
The goal of this project was to build a professional Excel dashboard to analyze sales performance and profitability, helping businesses understand their revenue, costs, and gross profit.
What I Did
I designed an Excel-based reporting solution using a sample dataset of 240 sales transactions.
The project includes:
I used Excel formulas such as VLOOKUP, SUMIFS, SUMIF, and IFERROR to build the reports and calculate key financial metrics.
Project Outcome
The final result is a structured Excel dashboard that provides a clear overview of sales performance, profitability, and business trends.
It helps users identify their best-performing products, compare regional results, and monitor monthly financial performance.
Note: This is a personal portfolio project created using fictional sample data.