What I Taught My Students Last Weekend (And Why It Matters in the Real World)
Most people think Excel is just for storing data.
But the moment you understand functions, Excel becomes a powerful analytical engine one that supply chain professionals, finance teams, HR analysts, and operations managers use every single day.
Here's a breakdown of what we covered last weekend and how each function connects to real work:
STATISTICAL FUNCTIONS — The Foundation of Data Summaries
➤ SUM — Add up total units shipped, total revenue, total costs.
Real world: A logistics manager uses SUM to calculate total freight spend across 50 routes.
➤ AVERAGE — Find the mean lead time, average order value, or average delivery days.
Real world: A procurement analyst uses AVERAGE to benchmark supplier performance month-over-month.
➤ MAX / MIN — Identify your highest-performing SKU or your worst delivery delay.
Real world: A warehouse supervisor uses MAX to flag the longest unresolved backorder.
➤ COUNT — Count how many transactions, invoices, or orders exist in a dataset.
Real world: An ops analyst uses COUNT to validate completeness of records before reporting.
TEXT FUNCTIONS — Because Dirty Data is Everywhere
Real data from ERPs, spreadsheets, and exports is messy. Text functions clean it.
➤ PROPER — Converts "VICTOR ugwu" → "Victor Ugwu". Useful when standardizing customer or vendor names.
➤ UPPER / LOWER — Ensures consistent formatting for codes, IDs, or categories.
➤ TRIM — Removes invisible spaces that break VLOOKUP matches and pivot tables. This one saves hours.
➤ LEN — Returns the character count of a cell. Use it to validate product codes, phone numbers, or SKU formats that must follow a fixed length.
DATE FUNCTIONS — Time is a Dimension in Every Dataset**
➤ TODAY() / NOW() — Dynamic timestamps. Use TODAY() in dashboards so your reports always reflect current date without manual updates.
➤ EDATE() — Calculate contract expiry dates, payment due dates, or reorder triggers.
Real world: A procurement team uses EDATE to auto-calculate when supplier contracts expire — 90 days before renewal.
➤ YEAR() / MONTH() — Extract time components for grouping and trend analysis.
Real world: Use MONTH() to segment sales by month in a pivot table without needing a separate column.
These aren't just "Excel tricks." They are the building blocks of every dashboard, report, and data model you'll ever build in your analytics career.
And we're just getting started. 🚀
🎓 SUPPLY CHAIN ANALYTICS BOOTCAMP — Cohort Starts March 27th
Onboarding has officially begun, and in a few days I'll be dropping the full curriculum we'll be working through together.
If you work in supply chain, logistics, procurement, or operations and you want to move from spreadsheet user to data-driven analyst — this bootcamp is built for you.
💰 Investment:
- Full: ₦100,000 / $85
- Early Bird: ₦80,000 / $65 (limited slots)
✅ 50% upfront payment accepted
📩 To register or ask questions:
Email: ugwuvictor395@gmail.com
WhatsApp: 08087508823
Drop a "INTERESTED" in the comments or send me a DM — let's get you skilled up before Q2 ends.
#SupplyChainAnalytics #Excel #DataAnalytics #Bootcamp #LearningAndDevelopment #Analytics #ExcelFormulas #SupplyChain #ProfessionalDevelopment #VictorChideraUgwu