Abegunde Anthony

@ObohX Don't know the third one exist, Thank you for the free_ lecture Another tips secured

One of the biggest mindset shifts in Excel is understanding "Cell References" Most people learn formulas like: =SUM(B2:B10) …but don’t really understand *why* formulas behave differently when copied across rows and columns. That’s where Cell References come in. There are 3 major types: 📌 Relative Reference → `A1` 📌 Absolute Reference → `$A$1` 📌 Mixed Reference → `A$1` or `$A1` And understanding when to use each one changes everything. Relative Reference (`A1`) This changes automatically when copied. Example: If you copy: ```excel =A1+B1 ``` down one row, it becomes: ```excel =A2+B2 ``` Excel assumes you want the formula to move with the data. Best used for: ✔ Row-by-row calculations ✔ Totals ✔ Repetitive calculations across datasets Absolute Reference (`$A$1`) This locks both the row and the column. No matter where the formula is copied, the reference stays fixed. Example: ```excel =A2*$F$1 ``` If `$F$1` contains a tax rate or exchange rate, every calculation will always reference that exact cell. Best used for: ✔ Fixed rates ✔ Constants ✔ Parameters ✔ Tax/discount calculations Mixed Reference (`A$1` or `$A1`) This locks either: * the row or * the column but not both. Example: `A$1` → Row is locked → Column can change `$A1` → Column is locked → Row can change This becomes extremely useful in: ✔ Dynamic tables ✔ Matrix calculations ✔ Forecast models ✔ Advanced reporting structures The interesting thing is this: Most Excel mistakes are not formula mistakes. They’re reference mistakes. People think Excel is “calculating wrong” when in reality the formula is pointing to the wrong cells after being copied. That’s why understanding references is such a major turning point. Once you understand how Excel thinks about references, formulas stop feeling random and start becoming predictable.

On today's Episode of Analysis of the Walmart Sales . Today, I created Pivot Tables, the foundation for the Dashboard creation. The Pivot tables show summary of the Dataset making it easy to extract meaning and insights

a new 100% Microsoft voucher opportunity is now available. *Registration closes on June 8.* 🔗 Join the Group Here: chat.whatsapp.com/Ew2U2z150DE7QK… Serious minded people please, don't collect if you are not ready. Thank you.

Keep an eye out, as I'll be checking in daily to report on the analysis progress.

I proceeded to insert new columns into the data table for easy analysis. The columns included: 1. Weekdays 2. Months 3. Daytime 4. Satisfaction level. The additions will help in tracking sales at different times of the day and on weekdays.

Working on a dataset that contains sales information across 3 different branches of Walmart Business Company. What I have done so far I cleaned the data using Power query; Standardized the data; removed duplicate entries and empty rows before loading into Excel workbook.

@ezekiel_aleke Thank you for what you do for the community Sir I will definitely watch this

If you know basic Power BI I beg you in the name of God Watch this video

@KoladeThevetguy The man teaches in different tutorials in Ibadan. My encounter with him was at Apex tutorial

@Bingabs20 He taught me too😂❤️

Kasabubu is the man, the man at the end. He's a wordsmith with an impeccable command of English He taught me English while seeking admission to Uni

@PeterFatd1 Early morning dose of motivation The power of consistency

I didn’t start LinkedIn with a big plan or perfect strategy. It started in October 2024. I remember clearly — I reached out to my boss, Mr. Segun Ebenezer Olaniyan, and asked him to be my mentor. Instead of just accepting it quietly, he gave me a simple instruction: “Follow me on LinkedIn.” That one sentence changed everything. I started showing up. Not perfectly, not as an expert — just consistently. Learning, posting, sharing small wins, and documenting my journey in data analytics. Somewhere along the way, things began to shift. I found my path in data analytics more clearly. I started growing not just in knowledge, but in confidence. One step at a time, I began training others — and today, I’ve been able to impact 100+ students in data analytics, both locally and globally. The feedback I receive from students keeps me going. People are getting results. People are learning. People are building careers. And that reminder matters more than numbers. Still, the numbers came too. 12,000+ followers on LinkedIn. And it didn’t stop there — I opened a YouTube channel, and it has grown to 1,000+ subscribers and 500k+ viewers, all built from the same simple principle: just start and stay consistent. If there’s anything I’ve learned from this journey so far, it’s this: You don’t need to have it all figured out before you begin. Start messy. Start small. Start unsure. But start. Because you don’t arrive all at once — you grow into it, day by day. We’re not there yet. But we’re definitely getting better.

If "Hmm" can pull 4.4M impressions, then at least 1M of you can amplify this: I'm building interactive software for Anatomy and Pathologies specifically in Black skin. RT if you believe it matters.

@omoalhajaabiola @RaenestApp @MusawirRaji A platform that understands the African freelancer! I love @Raenest because the virtual USD cards actually work for my subscriptions, and the free NGN withdrawals save me so much in fees. It’s seamless, transparent, and literally the only global partner I trust with my earned $$$

@RaenestApp said I should pick 30 people for the cold emailing course. This is for freelancers with an active Raenest account. The cold emailing course is the best course for freelancers. Ask @MusawirRaji if I lie So to be selected, tell me what you like about Raenest

In today episode of data analysis learning. I delve into the world of Power_Pivot. Still learning and evolving

@Femiforge This is timely Thank you for the nudge

Not everyone has a senior analyst to tap them on the shoulder. Not everyone has a mentor. Not everyone has a team. Some people are figuring this out completely alone. If AI is your thinking partner when no one else is available, that's not weakness, That's resourcefulness.

My favorite features? Data Column Distribution & Profiling! 📊 It enables you to easily spot data loopholes by showing the percentage of valid data, errors, and empty rows. Plus, Column Statistics gives a great statistical analysis at a glance. #PowerQuery #Excel #Datafam

Big on ETL! 🛠️ 📥 Extract: Import data from almost anywhere (CSV, PDF, Web, SQL). 🧹 Transform: A gem for workflow automation! Seamlessly clean data, remove duplicates, replace missing values, and make quick corrections 📤 Load: Push the prepped data right into your workbook.

Finished the Excel Fundamentals track on @DataCamp a few months ago, and now I'm taking on a new challenge: exploring the world of Power Query! 🚀 ​Power Query is an absolute powerhouse for data processing built right into Excel (and Power BI). Here is why it's so great: 👇

@Mr_Akinlabi 🔥🔥🔥 A great dashboard on the way

@Mr_Akinlabi @MayoMN_RadRes @RobloxNMH @UCSFMEDICALCENT @BSPH_CHS @MayoClinic Great one. Will be on your page to learn once the meal is ready

This week, I’m working on a healthcare dataset focused on patient appointments, hospital operations, and clinical outcomes. The dataset includes: • Patient demographics & history • Appointment status (Completed, No-show, Cancelled) • Diagnosis & treatment records • Hospital & provider details • Revenue (appointment fees & insurance providers) My focus: → Cleaning & structuring into a proper data model (fact + dimension tables) → Handling missing diagnosis/treatment values → Preparing it for dashboarding Looking forward to turning raw healthcare data into meaningful insights. #DataAnalytics #HealthcareAnalytics #Buildinpublic

Still learning Over the weekends I got my hands dirty replicating @ObohX dashboard. This is to put into practice the excel course I took on Datacamp via the one year Scholarship received through @DataCamp X @DataFestAfrica. The dashboard tells the story of Nigeria Car Markets.