Data Analyst helping beginners master Excel, SQL & Python 💡 | Daily tips & roadmaps | DM for resources | Abuja | Lafia
Joined February 2024
- Tweets 424
- Following 190
- Followers 37
- Likes 1,371
123 Photos and videos
Jun 13
How do you handle numbering lists in Excel? 📊
Noob: Manually typing them
Beginner: Click and drag the fill handle
Pro: Alt H F I S (Series shortcut)
Advanced: =SEQUENCE(32)
Stop wasting time on manual entry
What's your level ? 👇
#Excel #DataAnalytic #Productivity
1
2
9
Jun 12
🚀 How to ace your Excel interview in 60 seconds! 📊
Master XLOOKUP to pull data instantly:
1️⃣ Select lookup_value
2️⃣ Select lookup_array & press F4 to lock it
3️⃣ Select return_array & press F4
4️⃣ Drag down to fill the rest!
#ExcelTips #CareerHack #Productivity
1
2
74
Jun 12
Stop cross-checking lists manually! 🛑
Here is how to spot missing items instantly in Excel:
=FILTER(All_Items, COUNTIF(Current_Stock, All_Items)=0)
This formula cross-references your main list against your current stock and automatically outputs what's missing💡
#ExcelTips
1
2
12
Jun 12
Tired of manually fixing messy line breaks in Excel? 😫 There's a faster way!
1️⃣ Press Ctrl H to open Find and Replace.
2️⃣ In "Find what", press Ctrl J (you’ll see a tiny flashing dot).
3️⃣ In "Replace with", hit the Spacebar.
4️⃣ Click Replace All!
#ExcelTips #ProductivityHack
1
2
22
@awizee_1
@dev_awizee
Let's help each other grow
I always follow back
1
2
14
@awizee_1
@dev_awizee
I always follow back immediately
1
3
14
Jun 11
Just built this sleek Auto Sales Dashboard in Excel!
📊 $9.76M total sales
📈 $277K avg price
📦 96K units ordered
Product mix, top countries/cities, interactive slicers for Deal Size, Product Line & Status — all with PivotTables, slicers & clean design
What do you think? 👇
1
2
16
May 28
New to Excel? Stop manually typing dates!
Use =TODAY() for current date or =EOMONTH(A1,0) to get the last day of any month
Saves time when preparing monthly reports
Who else struggles with dates in Excel?
Drop a 🔥 if this helps
Reply 'EXCEL' for my free 7-Day Excel Roadmap.
1
9
May 24
Starting Data Analysis in 2026 ?
Most beginners waste weeks on VLOOKUP
Do this instead:
Press ALT H O I W (auto column width)
Use XLOOKUP (it’s VLOOKUP but better)
=XLOOKUP(lookup_value, lookup_array, return_array)
Save this
Reply 'EXCEL' for my 7-day Excel roadmap
25
May 23
Hot take: Learning Power BI without learning proper data cleaning first is a waste of time
Garbage in, garbage out
Focus on cleaning first, then visualization
Who agrees?
#PowerBI #DataAnalysis
13
May 23
Excel Tip: Use PivotTables instead of manual summing for sales reports
Drag Region to Rows, Amount to Values → Done in 20 seconds
Nigerian analysts, this one sweet pass garri 😌
Reply 'PIVOT' for my top 5 Pivot tricks
#ExcelTips #DataAnalysis
2
May 23
Relatable beginner struggle:
You finally understand VLOOKUP today… then tomorrow you forget everything 😭
Who else has been here?
The secret? Stop watching only
Practice daily small tasks
Reply “VLOOKUP” if you want a practice file
#ExcelTips
5
May 23
Be honest (especially if you’re in Abuja/Lagos):
How long have you been “learning data”?
A. 0-3 months
B. 3-6 months
C. 6-12 months
D. 1 year but still stuck
Vote reply your stage
#DataAnalysis #Beginners
5
May 23
Beginner Roadmap to First Data Job(2026 edition)
Master Excel & Google Sheets
Learn SQL (focus on joins & aggregations)
Basic Python (Pandas)
Build 3 portfolios projects
Start applying even with 0 exp
Part 1/5
Want the full roadmap?
Reply “ROADMAP”
#DataCareer #SQLTips
11
May 23
Python one-liner every beginner should know:
df.isnull().sum() → shows all missing values instantly
No more manual checking!
Save this
Reply 'PYTHON' for my free Python for Data roadmap
#Python #DataAnalysis
2
May 23
Saturday reminder to every beginner in Abuja and Naija:
You don’t need to be a genius
You just need to be consistent
30 minutes daily > 5 hours once a month
Your data analyst era is coming
Keep pushing 💪
Who’s practicing today?
Reply “I’m in”
#DataCareer #Motivation
2
13