Odd Pelle

Data Analyst Enthusiast | Data Entry Specialist

[Odd Pelle @OddPelle]

@cashin_app

[Odd Pelle @OddPelle]

@ABUJAPLUG Data Entry and AI trainer

[Odd Pelle @OddPelle]

@sheisblank_ I'm still here ohh

[Odd Pelle @OddPelle]

@sheisblank_ I am

[Odd Pelle @OddPelle]

@DabereNnamani Internship

[Odd Pelle @OddPelle]

It is about setting rules and letting logic drive outcomes.

Day 17 done. 🚀

#DataAnalytics
#Excel
#DataAnalysis
#LearningInPublic
#AnalyticsJourney
#BusinessIntelligence
#ExcelTips
#LogicalFunctions
#DataSkills

[Odd Pelle @OddPelle]

𝐃𝐚𝐲 𝟏𝟕 𝐨𝐟 𝐦𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 — 𝐋𝐨𝐠𝐢𝐜𝐚𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥📊

Today I learned how Excel handles decision-making using logical functions:
• IF → Test a condition and return results
• AND →

🧵

[Odd Pelle @OddPelle]

TRUE only if all conditions are met
• OR → TRUE if at least one condition is met
• NOT → Reverses a logical result
• IFS → Cleaner alternative to nested IF statements

𝐁𝐢𝐠 𝐭𝐚𝐤𝐞𝐚𝐰𝐚𝐲:
Analysis is not just about numbers.

[Odd Pelle @OddPelle]

Everything else builds on them.

Day 16 done. Onward. 🚀

#DataAnalytics #Excel #DataAnalysis #LearningInPublic #AnalyticsJourney #BusinessIntelligence #ExcelTips #DataSkills

[Odd Pelle @OddPelle]

𝐃𝐚𝐲 𝟏𝟔 𝐨𝐟 𝐦𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 — 𝐄𝐱𝐜𝐞𝐥 𝐂𝐨𝐫𝐞 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 📊

Today I strengthened my foundation with essential Excel functions:
• SUM (+ ALT + =) → Add values quickly
• COUNT → Count numeric cells
• COUNTA →

🧵

[Odd Pelle @OddPelle]

Count non-empty cells
• COUNTBLANK → Count empty cells
• AVERAGE → Find the mean
• MIN / MAX → Find smallest & largest values
• SMALL / LARGE → Find nth smallest or largest

𝐁𝐢𝐠 𝐭𝐚𝐤𝐞𝐚𝐰𝐚𝐲:
Great analysis starts with accurate calculations.
Master the basics.

[Odd Pelle @OddPelle]

#DataAnalytics #Excel #DataAnalysis #LearningInPublic #AnalyticsJourney #BusinessIntelligence #ExcelTips

[Odd Pelle @OddPelle]

𝐃𝐚𝐲 𝟏𝟓 𝐨𝐟 𝐦𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 — 𝐎𝐫𝐠𝐚𝐧𝐢𝐳𝐢𝐧𝐠 𝐃𝐚𝐭𝐚 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥📊

Today I learned how to structure and extract insights using:
• SORT → Organize data (A–Z, smallest to largest, newest to oldest)
• FILTER → Display only data
🧵

[Odd Pelle @OddPelle]

that meets specific criteria
• Advanced Filter → Apply complex criteria and extract unique or refined datasets

𝐁𝐢𝐠 𝐭𝐚𝐤𝐞𝐚𝐰𝐚𝐲:
You cannot analyze what you cannot organize.

SORT brings order.
FILTER brings focus.
Advanced Filter brings control.

Day 15 done. 🚀

[Odd Pelle @OddPelle]

Knowing when to use position vs matching text makes all the difference.

Day 14 done. My Excel mastery continues. 🚀

#DataAnalytics #Excel #DataCleaning #LearningInPublic #AnalyticsJourney #BusinessIntelligence #ExcelTips

[Odd Pelle @OddPelle]

𝐃𝐚𝐲 𝟏𝟒 𝐨𝐟 𝐦𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 — 𝐄𝐱𝐜𝐞𝐥 𝐓𝐞𝐱𝐭 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 📊

Today I learned how to find and replace text more precisely in Excel.

Here’s what I explored:
• FIND → Returns position of a character in a text (case-sensitive)

🧵

[Odd Pelle @OddPelle]

• SEARCH → Returns position of a character in a text (not case-sensitive)
• REPLACE → Replaces text by position
• SUBSTITUTE → Replaces matching text (can replace all or specific occurrences, case-sensitive)

𝐁𝐢𝐠 𝐥𝐞𝐬𝐬𝐨𝐧:
Cleaning data is about control.

[Odd Pelle @OddPelle]

𝐁𝐢𝐠 𝐭𝐚𝐤𝐞𝐚𝐰𝐚𝐲:
Clean data first. Analyze second.

Day 13 done. More functions to master next. 🚀

#DataAnalytics #Excel #DataCleaning #LearningInPublic #AnalyticsJourney #BusinessIntelligence #ExcelTips

[Odd Pelle @OddPelle]

𝐃𝐚𝐲 𝟏𝟑 𝐨𝐟 𝐦𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 — 𝐄𝐱𝐜𝐞𝐥 𝐓𝐞𝐱𝐭 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬📊

Today I learned how powerful text functions are for data cleaning.

In real datasets, text is rarely perfect. Extra spaces, mixed formats, embedded codes, it’s messy.

🧵

[Odd Pelle @OddPelle]

Here’s what I implemented:
• LEFT() → Extract from the beginning
• RIGHT() → Extract from the end
• MID() → Extract from a specific position
•TRIM() → Remove extra spaces
• LEN() → Count characters

Example:
=LEFT("Hello", 2) → "He"
=TRIM(" Hello ") → "Hello"