Data Analytics — Next cohort Starts Oct 24

Enroll Now
// Community Driven

Excel Projects

E-commerce Sales Dashboard

Beginner

Clean and analyze a real 540,000-row online retail dataset entirely in Excel. Handle duplicates, cancellations, and guest checkouts, then build an interactive PivotTable dashboard with slicers that reports true net revenue.

Prerequisite(s) :

Basic Excel formulas, sorting, filtering, Excel 365 or 2021 (needed for XLOOKUP)

Skills to be Learned :

  • Excel Tables
  • PivotTables
  • PivotCharts
  • Slicers
  • XLOOKUP
  • Data Cleaning
  • Dashboard Design
View Project

Explore other categories

AI for Data Analytics projectsPower BI projectsPython projectsStatistics projectsTableau projects

Submit your Projects

Would you like to contribute your own projects to Gradient Projects Hub? Share your project with us and we will work with you to feature it here.

Submit Your Project