Title: Excel Data Cleaning for Dashboard Ready Sheet
Description: Prepared raw cafe sales data for reporting. Fixed Excel serial number date bug (45177) and cleaned product names.
Tool: Microsoft Excel
Title: Duplicate Removal & Data Standardization
Description: Cleaned 200+ blank rows and standardized sales channels for a US cafe client. Made data ready for dashboard.
Tool: Microsoft Excel
Title: Excel Power Query - Messy to Clean Automation
Description: Automated data cleaning using Power Query. Fixed duplicate categories like In-store / In Store and date errors. Saved 6 hours of manual work.
Tool: Microsoft Excel
I cleaned 9,540 messy cafe sales rows yesterday. Here's what I found š
The client had:
ā 'In-store' written in 4 different ways (In-store, In Store, INSTORE, in_store)
ā 45177 showing as a date (Excel serial number bug)
ā 200+ blank rows breaking the dashboard
How I fixed it in...
I cleaned 9,540 messy cafe sales rows yesterday. Here's what I found š
The client had:
ā 'In-store' written in 4 different ways (In-store, In Store, INSTORE, in_store)
ā 45177 showing as a date (Excel serial number bug)
ā 200+ blank rows breaking the dashboard
How I fixed it in...
