The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Social Media & Paid Media Strategy Tre Sorelle
I supported Tre Sorelle, a Saudi luxury fashion brand, with social media growth, paid media planning, audience research, competitor research, and organic community engagement.
What I worked on
Paid Media Strategy
Built a structured audience-testing approach for GCC markets.
Planned separate age-group ad sets to identify stronger audience segments.
Supported TikTok Traffic campaign setup, including targeting, placements, budget and creative configuration.
Reviewed creative performance signals such as views, engagement and play time to inform creative testing decisions.
Assessed Meta Business access and tracking requirements and identified issues preventing Instagram ad setup.
Audience & Competitor Research
Researched luxury, modest-fashion and abaya audiences across the GCC.
Analysed competitor positioning, content styles, visual presentation and engagement approaches.
Identified opportunities for Tre Sorelle to strengthen its organic presence and connect with more relevant audiences.
Organic Growth
Started strategic community engagement by researching relevant fashion audiences and conversations.
Engaged with relevant users through existing community conversations rather than relying on mass or artificial engagement.
Focused on building genuine awareness and identifying potential customers and advocates.
Tools
TikTok Ads Manager · Meta Business Suite · Shopify · Instagram · Canva · Google Sheets · Google Docs
Project focus
The overall objective was to create a more structured approach to brand visibility, audience growth, engagement, website traffic and future customer acquisition, while using research and performance data to guide decisions.
Great strategy work! 👏
“Building an automated Excel Budget Planner with dashboards, expense tracking, and financial insights.”
Do you have unstructured, messy, or duplicate data in Excel or Google Sheets? I will help you clean, format, and organize your files so you can easily understand your data without any confusion.
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?