“Future Data Analyst | Excel • SQL • Power BI • Python | Sharing my learning journey, projects & insights publicly | Solving problems one dataset at a time”
Today’s 3MTT NextGen class reminded me that the “basics” in Excel are more important than they look 😅
Workbook structure, formatting, data types, organizing datasets properly… small things, but they can completely affect your analysis if ignored.
Started my 3MTT NextGen Data Analysis journey today 🚀
Learned: – What data & data analysis really mean
– Types of analysis (descriptive, predictive, etc.)
– Key steps in analysis
Biggest takeaway:
👉 Clean data = accurate insights
#3MTT#NextGen#JeefAfrica#DataAnalytics
Excel shortcuts that will save you time 👇
Ctrl + T → Create table
Ctrl + Shift + L → Filter
Ctrl + Arrow → Jump fast
Alt + = → AutoSum
Small tricks. Big difference.
#ExcelTips#DataAnalytics#Productivity
Was trying to subtract birth_date from survey_date in Excel Power Query…
The option was inactive 😤
Tried everything… nothing worked.
Turns out I also selected patient name 😅
Deselected it → it worked instantly.
Small mistakes will humble you 😂
#ExcelTips#powerquery#excel
Excel tip:
If your numbers aren’t working properly, check this 👇
They might be stored as TEXT, not numbers.
That’s why formulas, sorting, or charts fail.
Fix it → everything works.
#DataAnalytics#ExcelTips
Cleaned the dataset ✅
What looked simple at first? Not even close 😅
Duplicates, missing values, wrong formats…
Took time, made mistakes, learned a lot.
Clean data >>> everything.
#DataAnalytics#BuildInPublic
Need help 👇
I’ve cleaned almost everything in this dataset, but the date column is a mess 😅
Mixed formats (DD/MM, MM/DD, etc.) and I’m struggling to standardize it properly in Excel.
Any tips or functions I should use?
#DataAnalytics#BuildInPublic#Excel
Spent hours trying to clean a dataset today…
Got frustrated.
Stayed up late.
Still couldn’t fix everything.
Not every day is a win.
But I understand it better than yesterday… and that counts.
#DataAnalytics#BuildInPublic
Day 2 🚀
Started the Data Cleaning Challenge and the dataset is messy 😅
Inconsistent text, mixed dates, missing values, wrong totals…
Realizing again: clean data > fancy dashboards
Time to fix everything step by step 💻
#DataAnalytics#BuildInPublic#TechWithEuniceChallenge
@RONiNmedia000 Yeah, for real… this part of the journey doesn’t get talked about enough.
It’s a market sales dataset from a data cleaning challenge — full of inconsistencies, mixed formats, missing values, wrong totals… the kind that looks simple
Still figuring it out step by step though.
This is the dataset I’m working on for Day 2👇
Looks normal at first… until you notice: inconsistent text, mixed dates, missing values, duplicates 😅
Real reminder: clean data > fancy dashboards
Time to fix it 💻
#DataAnalytics#BuildInPublic#TechWithEuniceChallenge