Welcome to my Excel Projects repository!
This collection contains a wide range of data analysis, reporting, visualization, and dashboard-building projects created using Microsoft Excel. The goal of this repository is to demonstrate the power of Excel as an analytical tool and highlight practical, real-world use cases across business, finance, operations, HR, marketing, and more.
Excel remains one of the most widely used tools for analytics and decision-making. Through these projects, I showcase strong skills in data cleaning, transformation, formula-based automation, dashboard creation, and storytelling with data.
This repository acts as a centralized portfolio of my Excel work, demonstrating:
- Strong understanding of Excel formulas and functions
- Ability to clean, transform, and organize raw data
- Creation of intuitive and interactive dashboards
- Practical business reporting and KPI tracking
- Problem-solving skills using Excel’s built-in tools
- Knowledge of analytical thinking and visualization techniques
Each project focuses on solving real-world analytical challenges and presenting insights clearly and professionally.
- Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH
- Logical functions: IF, AND, OR, IFS
- Aggregation: SUMIFS, COUNTIFS, AVERAGEIFS
- Text functions: LEFT, RIGHT, MID, TRIM, CONCAT, TEXT
- Date & time functions
- Error handling: IFERROR, ISERROR
- Excel Tables
- Data Validation
- Conditional Formatting
- Power Query for data cleaning (optional)
- Sorting & Filtering
- PivotTables & PivotCharts
- Slicers & Timelines
- Line, bar, column, pie, combo charts
- KPI cards & summary visuals
- Dashboard layout design principles
- Formula-driven automation
- Dynamic named ranges
- Interactive reports