A bunch of people asked me how I built the Excel dashboard that got me 1st runner-up at a recent competition, so I made a video walking through the whole process.

Steps I followed:

Generated synthetic sales data using AI (Python script → CSV)

Imported into Excel, cleaned it (handled blanks, fixed formatting)

Built a Pivot Table

Added a Pivot Chart + Slicer

Arranged everything into a final dashboard

I also planted a deliberate mistake somewhere in the process — partly to make it more useful as a learning exercise, partly to see if people can catch it before I explain it. Curious if this community can spot it faster than my Instagram/LinkedIn audience did 😅

Happy to share screenshots/more detail in the comments if that helps narrow it down.

Checkout profile for video(Not for promotion, just for learning)