Excel Projects

Advanced Excel solutions focused on data cleaning, reporting, dashboards, and business decision support.

Sales Performance Dashboard (Excel)

Built a dynamic Excel dashboard to analyze sales trends, revenue performance, and regional KPIs using formulas, pivot tables, and visual reporting.

Excel · Pivot Tables · KPIs · Dashboards

Enabled stakeholders to track sales performance at a glance, identify underperforming regions, and improve forecasting accuracy. Reduced manual reporting time significantly.

  • Pivot tables and pivot charts
  • Advanced formulas (VLOOKUP/XLOOKUP, IF, SUMIFS)
  • Conditional formatting
  • Interactive slicers
⭐ View on GitHub

Customer Data Cleaning & Analysis

Cleaned and structured raw customer data in Excel to support segmentation, trend analysis, and reporting.

Excel · Data Cleaning · Analysis · Reporting

Improved data accuracy and consistency, enabling better customer segmentation and more reliable business insights.

  • Data validation and deduplication
  • Text functions (LEFT, RIGHT, MID, TRIM)
  • Date handling and transformations
  • Summary analysis with pivot tables
⭐ View on GitHub

Financial Reporting & Budget Analysis

Designed Excel-based financial reports to track expenses, budgets, and variances for management review.

Excel · Financial Analysis · Budgeting

Supported financial decision-making by highlighting cost overruns, budget gaps, and spending trends.

  • Budget vs actual analysis
  • Variance calculations
  • Charts for executive summaries
  • Reusable reporting templates
⭐ View on GitHub