Dynamic Sales Summary Dashboard & Advanced Data Formatting

In this project, I transformed a raw e-commerce sales dataset into a clean, highly structured, and interactive summary dashboard using Microsoft Excel.

Key Achievements:

Data Formatting & Standardization: Cleaned the raw data and applied professional currency formatting to prices and total sales to ensure clear financial readability.

Interactive Search Feature: Created a dynamic drop-down list using Data Validation combined with the SUMIFS formula. This allows users to select any specific product and instantly view its real-time total sales revenue without changing the main table.

Professional Layout: Removed default gridlines and utilized a modern, high-contrast dark theme for headers to deliver a clean, business-ready interface.