Cover image for
Title: Excel Data Cleaning for

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

0

11

Cover image for
Title: Duplicate Removal & Data

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

0

14

Cover image for
Title: Excel Power Query -

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

0

12

Cover image for I cleaned 9,540 messy cafe

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 15 mins: ✅ Power Query - to standardize all text in 1 click ✅ TRIM() + PROPER() - to clean spaces & capitals ✅ Remove Duplicates + Fill Down - to fix blank cells Result: A 100% clean sheet ready for pivot tables. Saved 6 hours of manual work. If your Excel sheet is messy and your dashboard is not working, DM me. I will clean it in 24 hours. Tools: Microsoft Excel, Power Query, Google Sheets #Excel #DataCleaning #PowerQuery #Freelance

0

24

Abhinav Edarada

Excel Expert | Data Cleaning & Dashboards