Filter
Exclude
Time range
-
Near
Today, I walked into class expecting the usual “Where’s the formula?” panic. What I got instead was a room full of curiosity, a few skeptical eyebrows, and one student who whispered, “Is this… magic?” It wasn’t magic. It was a PivotTable. We started with raw data staff records, departments, allowances, and transaction types. Rows and columns stretched endlessly. Eyes started glazing over. Then came the shift. Step 1: Click inside the data. Step 2: Insert → PivotTable. Step 3: Let Excel find the range. Step 4: New worksheet—because clean data deserves a clean canvas. That’s when the real story began. I showed them how to drag fields like building blocks: · Departments into Rows · Allowances into Values Within seconds, the chaos turned into clarity. Academic: ₦662,365. IT: ₦636,308. Grand Total: ₦2,559,490. No formulas. No stress. Just insight. One student said, “Wait… so I don’t have to filter and sum manually anymore?” Another opened their own file and built a summary before lunch. By the end of the session, they weren’t just using PivotTables, they were thinking in them. What clicked? · They saw how dragging fields = asking questions of the data. · They learned that analysis isn’t about complexity, it’s about structure. · And they realized they already had the skills; they just needed the right tool. To every educator, analyst, or leader teaching data skills: Don’t underestimate the power of that first PivotTable moment. It’s not just a tool—it’s a mindset shift. If you’re new to PivotTables, try it today. One drag at a time, you’ll see your data tell a story you never knew was there. #DataAnalytics #Excel #PivotTables #TeachingData #StorytellingWithData #ExcelForAnalytics
1
13
5,956
Most courses don't show you the structure. They just say "join" and hope you trust them. Here's mine — openly. ───────────────────── The Supply Chain Analytics Bootcamp runs 7 weeks. Here's exactly what Weeks 1 & 2 look like: ───────────────────── WEEK 1 — Foundations & Analytics Thinking Before you touch a single formula, you need to understand why data matters in supply chain. Goal: Understand how data drives supply chain decisions. We cover: ✦ What Supply Chain Analytics really is ✦ Procurement, Inventory & Logistics Overview ✦ Types of Supply Chain Data ✦ Data Cleaning & Formatting Basics ✦ Sorting, Filtering & Numeric Functions ───────────────────── WEEK 2 — Descriptive Statistics for SC Decisions Now we go deeper. Numbers mean nothing without context. Week 2 teaches you how to read them. Goal: Summarize & interpret supply chain data. We cover: ✦ Mean, Median & Mode ✦ Range, Variance & Std. Deviation ✦ Demand & Lead Time Variability ✦ Outliers in Operations ✦ PivotTables & Summary Tables ───────────────────── This is what structured learning looks like. Not a dump of topics. A deliberate progression — from thinking, to analysis, to decision-making. ───────────────────── Every week builds on the last. By the time we hit Week 7, you won't just know Excel. You'll know how to think like a supply chain analyst. ───────────────────── This is not theory. It's structured, hands-on learning. ───────────────────── Investment ₦100,000 · $80 USD 🐦 Early Bird: ₦80,000 / $65 50% installment payment is guaranteed if you can pay full. 🚀 Cohort starts next week. Spots are limited. Early Bird Registration → selar.com/y738ee828n ───────────────────── #SupplyChainAnalytics #DataAnalytics #ExcelForAnalytics #Bootcamp #AfricaTech #SupplyChain #DataSkills #Analytics
1
3
9
1,431
Here's how the first 2 weeks of the Supply Chain Analytics Bootcamp are structured. Most people think analytics training means endless slides and jargon. This bootcamp is built differently. ───────────────────── WEEK 1 — Foundations & Analytics Thinking Goal: Understand how data drives supply chain decisions. ✦ What Supply Chain Analytics really is ✦ Procurement, Inventory & Logistics Overview ✦ Types of Supply Chain Data ✦ Data Cleaning & Formatting Basics ✦ Sorting, Filtering & Numeric Functions ───────────────────── WEEK 2 — Descriptive Statistics for SC Decisions Goal: Summarize & interpret supply chain data. ✦ Mean, Median & Mode ✦ Range, Variance & Std. Deviation ✦ Demand & Lead Time Variability ✦ Outliers in Operations ✦ PivotTables & Summary Tables ───────────────────── By Week 2, you're not just learning Excel. You're learning how to read supply chain data and make decisions with it. This is not theory. It's structured, hands-on learning. ───────────────────── Investment ₦100,000 · $80 USD 🐦 Early Bird: ₦80,000 / $65 🚀 Cohort starts next week. Spots are limited. Early Bird Registration → selar.com/y738ee828n ───────────────────── #SupplyChainAnalytics #DataAnalytics #ExcelForAnalytics #Bootcamp #AfricaTech #SupplyChain #DataSkills
3
13
35
1,821
📊 Free Workshop: Excel for Data Analytics 🔗 Register Link: tr.ee/Stx2HD 👨‍🏫 Mr. Sai | 🗓️ 8 Feb | ⏰ 11:00 AM IST #ExcelForAnalytics #DataAnalytics #FreeWorkshop #NareshIT #CareerSkills #SkillUpgrade
30
Day 5 of my Data Analytics journey 🚀 Learned Excel formulas used in real-world data prep: ✔ AND, OR, NOT for logic ✔ CONCATENATE for combining fields ✔ LEFT, RIGHT, MID for text extraction #ExcelForAnalytics #DataAnalyst
49
Building KPI tables today. Learning how totals, averages, counts, min & max are calculated — not just displayed. #DataAnalytics #ExcelForAnalytics #PivotTables #DataAnalysisJourney #AnalyticsInProgress #LearningInPublic #AspiringDataAnalyst #ExcelTips #AnalyticsThinking
7
KAHE - The Faculty of Pharmacy is organizing a One-Day Workshop on “Pharmacy Analytics with Excel for Data Management, Computation, and Visualization” on 13th December 2025 at 10.00 AM, at S Block. #FacultyOfPharmacy #OneDayWorkshop #PharmacyAnalytics #ExcelForAnalytics #KAHE
22
₦58M revenue loss, and even long-tenure “loyal” customers are leaving. Full breakdown dashboard on my GitHub (link in bio). Don’t forget to leave a ⭐️ #DataAnalytics #ExcelDashboard #ChurnAnalysis #BusinessIntelligence #DataStorytelling #AnalyticsExtra #ExcelForAnalytics
1
7
🚀 Transform Data into Decisions! 📲 Register Now:tr.ee/4BO2gp 📅 Date: 06th November ⏰ Time: 07:00 AM (IST) 📍 Mode: Classroom & Online #DataAnalytics #BusinessIntelligence #AshokIT #PowerBI #Tableau #PythonForDataAnalytics #SQLTraining #ExcelForAnalytics
14
Excel is a crucial part of the job for Data Analysts. This certificate is open to all levels of analysts and will cover all aspects of Excel as it pertains to data analytics. mors.org/Events/Certificates… #excel #excelforanalytics #probability #statistics #dashboards
Sorted... So what went wrong? In the MATCH part of the formula, I mixed up the value I was supposed to match with the entire range Excel was supposed to look in... Once I resolved it, the formula behaved as expected the result is this: #30dayofExcel #ExcelforAnalytics
1
Omo, wetin dey occurlate here... 😳😳😳 This thing is acting up gan No worry, na me n u today #30dayofExcel #ExcelforAnalytics #TransitioningtoDataAnalytics
1
1