Name Cannot be Blankš retweeted
5 weeks of learning.
EXCEL101 was practical, interactive, and most of all fun.
We covered a lot together: from basic data entry to Functions, Descriptive Statistics, Tables, Pivot Tables, Slicers/Timeline, Pivot Chart, Power Query, Power Pivot, DAX, Wireframing..
#Excelboss
Name Cannot be Blankš retweeted
THINK LIKE AN EXCEL BOSS WEEK 1 done ā
.
Unto week 2,you can still be part of this cohort.
Send me a DM
Come let's build Excel analysts @msexcel
#Excel #exceltutorial #excelmodeling #exceltips #ThinkLikeAnExcelBoss
Name Cannot be Blankš retweeted
Heyyyy!
I just launched my new YouTube channel Explore Data with Annie!!
If youāve ever wanted to understand data, switch into tech, or just learn practical skills the easy way, this channel is for you.
My first video is out already, and Iād really love your support.
Please check it out, subscribe, and share with someone who might need it.
YouTube: youtu.be/ez0a3n6J87U?si=mLqKā¦
Name Cannot be Blankš retweeted
Let's be honest about something most people won't admit
you've probably spent hours watching coding tutorials, nodding along, typing exactly what the instructor types, and at the end you felt... nothing. Maybe a bit accomplished for finishing, but also kind of empty.
Here's why:you didn't learn anything. You just proved you can copy.
I know that sounds harsh, but think about it. When you follow along step-by-step, your brain is on autopilot. You're not making decisions. You're not problem-solving. You're basically a human Ctrl+C, Ctrl+V machine. And the second you close that tutorial, everything is gone. All of it.
Real learning happens in the uncomfortable middle ground where you're trying to remember what to do next, and you can't. That moment when you think, wait, why did they use a LEFT JOIN here instead of an INNER JOIN?" ā that's when your brain actually wakes up.
Here's how I learn, and it should work for you, too.
After you finish a tutorial, close it. Don't rewatch it. Don't peek at the code. Instead, grab a different dataset ā it could be from Kaggle, could be your own data, doesn't matter ā and try to solve a similar problem from memory.
You're going to fail. You're going to forget the steps. You're going to write code that doesn't work. Perfect. That's exactly where learning lives.
When you get stuck, then go back and check. But only after you've tried. Because that struggle ā that annoying, frustrating feeling is your brain actually building the skill.
You'll be slow. You'll make mistakes. You'll wonder if you learned anything at all from that tutorial. But here's what's happening: you're forcing your brain to retrieve information instead of just recognizing it. Retrieval is what builds real memory.
If this changes how you think about learning, follow me for more honest takes.
Name Cannot be Blankš retweeted
November Data Analysis Challengeš
Open to everyoneš
1st prize 100,000
2nd 70,000
3rd 30,000
Here is the dataset: github.com/getnervs/Soft-Driā¦
Check here for submission guidelines: github.com/getnervs/Soft-Driā¦
Deadline: 30th November
Make sure you follow the guidelines
Name Cannot be Blankš retweeted
Listenā¦
If youāre in tech right now and the money hasnāt started coming in yet, I want you to hear me clearly:
You are not failing.
You are building.
Tech is not the kind of journey where you plant a seed today and harvest tomorrow.
Tech is the kind of journey where you plant a seed, water it every single day, and one day, out of nowhere, it becomes a forest.
Right now youāre learning.
Right now youāre debugging.
Right now youāre copying code from StackOverflow.
Right now youāre watching YouTube tutorials at 1am because the bug is embarrassing your destiny.
Right now youāre applying for jobs and nobody is replying.
Right now youāre wondering if you chose the wrong path.
But hear me:
Every skill you are building is compounding.
Every frustration is part of your foundation.
Every late night is shaping your future income.
Tech doesnāt reward the fastest.
Tech rewards the most consistent.
There are people earning millions today because they refused to quit during the season youāre currently in.
So donāt look at your bank account and assume thatās your value.
Donāt look at your current situation and assume thatās your future.
Your time is coming.
Every line of code you writeā¦
Every dashboard you buildā¦
Every SQL query you break and fix againā¦
Every project you completeā¦
ā¦is pushing you closer to the version of you that gets paid effortlessly.
Youāre not behind.
Youāre in progress.
Stay hungry.
Stay consistent.
Stay learning.
Stay applying.
Stay improving.
Because one day, the same skill that is stressing you todayā¦
Will be the skill that changes your life completely.
Keep going.
Your breakthrough in tech is loading.
Name Cannot be Blankš retweeted
Femi: This IF Function in Excel⦠how does it really work?
Me: Excelās IF Funtion is basically like a judge sitting in your cell. You give it a question, it looks at the situation, and it decides what answer to return.
Youāre not doing magic. Youāre just saying, āExcel, check this thing. If itās true, say this. If itās not, say that.ā
Thatās the whole idea.
Say you want to check if the number in A1 is greater than 5.
If it is, Excel should say āYES.ā
If itās not, it should say āNO.ā
Hereās the formula:
`=IF(A1>5,"YES","NO")`
Nothing complicated. Itās built on three simple parts:
1. What do you want Excel to check
2. What to show if the condition is true
3. What to show if itās false
Think of it like asking a friend, is the weather hot?
If they say yes, you wear a T-shirt.
If they say no, you grab a hoodie.
You set those up, Excel does the rest. Across hundreds of rows if you want.
And here's where it gets goodāonce you get the basic idea, you can build bigger logic. String multiple IFs together. Nest them. Layer them until your spreadsheet starts doing the thinking for you.
Want more beginner-friendly breakdowns? Stick around.
Name Cannot be Blankš retweeted
If youāre still struggling to navigate your data analysis journey, read this.
I know the struggles behind learning this skill especially if youāre self studying.
Some days, youāre unstoppable. Other days, you start wondering if youāre really cut out for this.
Read thread š§µš§µ
Name Cannot be Blankš retweeted
Day 1 of learning SQL: This is easy, just SELECT and FROM.
Day 3: INNER JOIN, LEFT JOIN, RIGHT JOIN.
Day 5: Staring at screen wondering if you're still learning SQL or ancient Greek
Have you been there before? š
Name Cannot be Blankš retweeted
Dashboard is finally ready š
š¤
I embarked on this project to answer one question:
In the last seven years, has it been EASIER or HARDER to get admitted into the University of First Choice @UnilagNigeria via the UTME route?
Name Cannot be Blankš retweeted
How would you rate yourself in Microsoft Excel ?
A. Master
B. Professional
C. Intermediate
D. Beginner
Be honestlyāNo shame in being real.
Name Cannot be Blankš retweeted
Spotify pays attention to when you skip a song. Because that moment tells them more about your taste than anything else.
They found that most people decide if they like a song within the first five seconds.
Thatās a small action, but it carries meaning.
Your attention, your hesitation, your quick decisions, your patterns āthose are all data points. Theyāre recorded, compared, analyzed and studied to understand what you prefer and why.
This is where data analysis shows up in everyday life.
Someone is responsible for:
⢠Collecting those skip events
⢠Cleaning the data
⢠Spotting patterns across millions of listeners
⢠Turning that into decisions and actionable insights.
So when people ask āWhat does a data analyst actually do?ā
Hereās the answer:
They look into tiny behaviors, study and analyze them , trace the pattern, and explain what they mean to make decisions
Data isnāt just numbers.
Itās people making tiny choices, over and over, without realizing it.
And our job is to understand those choices..
Name Cannot be Blankš retweeted
Hey #datafam
My Think Like an Excel Boss training is starting this November.
It's not just formulas.
Itās mindset + real-world analytics + dashboard storytelling.
Use this link to join the WhatsApp group: chat.whatsapp.com/IAXdUqTmbSā¦
#Data #BusinessIntelligence #MicrosoftExcel
Name Cannot be Blankš retweeted
Hiring: Data Analyst (Abuja)
Job Type: 3months Contract
The Data Analyst will lead and support the analysis of qualitative data collected from field officers, including health-care providers and community leaders.
Interested?
pacproject.paperform.co/
Name Cannot be Blankš retweeted
Free Datasets to practice data analytics projects
1. Enron Email Dataset
Data Link: cs.cmu.edu/~enron/
2. Chatbot Intents Dataset
Data Link: github.com/katanaml/katana-aā¦
3. Flickr 30k Dataset
Data Link: kaggle.com/hsankesara/flickrā¦
4. Parkinson Dataset
Data Link: archive.ics.uci.edu/ml/datasā¦
5. Iris Dataset
Data Link: archive.ics.uci.edu/ml/datasā¦
6. ImageNet dataset
Data Link: image-net.org/
7. Mall Customers Dataset
Data Link: kaggle.com/shwetabh123/mall-ā¦
8. Google Trends Data Portal
Data Link: trends.google.com/trends/
9. The Boston Housing Dataset
Data Link: cs.toronto.edu/~delve/data/bā¦
10. Uber Pickups Dataset
Data Link: kaggle.com/fivethirtyeight/uā¦
11. Recommender Systems Dataset
Data Link: cseweb.ucsd.edu/~jmcauley/daā¦
Source Code: bit.ly/37iBDEp
12. UCI Spambase Dataset
Data Link: archive.ics.uci.edu/ml/datasā¦
13. GTSRB (German traffic sign recognition benchmark) Dataset
Data Link: benchmark.ini.rub.de/?sectioā¦
Source Code: bit.ly/39taSyH
14. Cityscapes Dataset
Data Link: cityscapes-dataset.com/
15. Kinetics Dataset
Data Link: deepmind.com/research/open-sā¦
16. IMDB-Wiki dataset
Data Link: data.vision.ee.ethz.ch/cvl/rā¦
17. Color Detection Dataset
Data Link: github.com/codebrainz/color-ā¦
18. Urban Sound 8K dataset
Data Link: urbansounddataset.weebly.comā¦
19. Librispeech Dataset
Data Link: openslr.org/12
20. Breast Histopathology Images Dataset
Data Link: kaggle.com/paultimothymooneyā¦
21. Youtube 8M Dataset
Data Link: research.google.com/youtube8ā¦
Name Cannot be Blankš retweeted
September 9th, 1947.
Grace Hopper's computer stops working. Her team can't figure out why.
They open it up and find a moth stuck inside the machine
Grace tapes it into her log book and writes: "First actual case of bug being found."
That's where the word "bug" comes from. An actual insect breaking a computer.
Fast forward to Today ,when your code doesn't work, you're debugging.
You're looking for the problem, just like Grace did.
Except now, the bugs aren't physical. They're mistakes in the code. Typos. Logic errors. Things you can't see or touch.
But we still call them bugs because of that one moth in 1947.
Name Cannot be Blankš retweeted
you ever follow a tutorial word for word ā same code, same dataset, same everything ā theirs works perfectly and yours just... doesn't
like, WHERE did i go wrong. we're literally typing the same things
Name Cannot be Blankš retweeted
$28.2 Million. That's how much money was at risk when I opened this dataset.
I wasn't expecting it.
I thought I was just building another loan dashboard. Clean the data, add some charts, and call it a day.
But then I saw itāburied in the numbersāa quiet crisis hiding in plain sight.
Here's what happened
A bank was processing thousands of loan applications every month. On paper, everything looked fine. Growth was up. Funding was strong. The executive summary would've made anyone smile.
But I created a helper column. Just one. To separate Performing Loans from Non-Performing Loans.
And that's when the story changed.
13.8% of loans weren't being repaid.
5,300 borrowers. $65.5 million funded. Only $37.3 million recovered.
The rest? Lost to defaults and charge-offs. Almost $30 million in risk that no one was actively watching.
So I didn't stop at the KPIs. I went deeper:
ā
Built MTD/MOM comparison logic to track momentum
ā
Used Pivot Tables to isolate problem areas
ā
Added slicers so stakeholders could filter by loan purpose and grade
ā
Created a two-page navigation systemāone for performance, one for risk
The result? A dashboard that didn't just report numbers. It told a story. More importantly, it gave leadership a path forward
What happened after I discovered this?
The full story is in here ā shorturl.at/ijZyx

























