Beginner Data Analytics with Excel
Go from zero experience to a finished dashboard, using a real, messy dataset.
EDAH's flagship program. You'll learn Excel the way it's actually used on the job — cleaning disorganized data, building formulas that answer real questions, and finishing with a capstone dashboard you can show in an interview.
What You Will Learn
Week 1 — Introduction to Data Analytics
- What data analytics is and where it fits in a business
- The Excel interface, navigation, and file basics
- Setting up your first workbook
Week 2 — Basic Excel Formulas & Functions
- SUM, AVERAGE, IF, COUNTIF, SUMIF
- VLOOKUP / XLOOKUP for combining data across sheets
- TRIM, IFERROR, INDEX & MATCH
Week 3 — Data Cleaning & Preparation
- Removing duplicates and standardizing formats
- Handling missing values and outlier detection
- Intro to Power Query for repeatable cleaning
Week 4 — Data Visualization & Storytelling
- PivotTables and PivotCharts
- Building a dashboard from scratch
- Presenting insights clearly to a non-technical audience
Capstone Project
Jumia Sales Performance Analysis
Working in a small group, you'll take a deliberately messy, real e-commerce dataset — modeled on Jumia sales data — and turn it into a finished, interactive Excel dashboard. You'll uncover sales trends, top products, regional performance, and present data-driven recommendations, exactly like a real workplace deliverable.
Who Should Join?
- Complete beginners — no prior Excel or analytics experience needed
- Career changers exploring data analytics as a new path
- Students who want a practical skill alongside their degree
- Small business owners who want to understand their own sales data
- Anyone who has used Excel casually but never learned it properly
What You Need
- A laptop (Windows or Mac) — a phone alone isn't practical for this work
- Microsoft Excel installed (Excel 2016 or later, or Microsoft 365)
- A stable internet connection for live Google Meet sessions
- Commitment to attend live sessions and complete weekly assignments
Why Learn with EDAH?
- You work with a real, messy dataset from day one — not a clean textbook example
- Live mentorship from a working data analyst, not pre-recorded videos
- A genuine capstone project you can link on LinkedIn or show in an interview
- An active WhatsApp community of learners and alumni
- Free training, with a certificate available for those who want one
Training Outcomes
- Confidently clean and organize disorganized, real-world data
- Build formulas and PivotTables without looking up every step
- Design a working dashboard that answers real business questions
- A completed capstone project for your portfolio
- A CV template tailored to data analyst roles
Certificate Information
Everyone who completes the program receives an EDAH Beginner Data Analytics (Excel) Certificate of Completion. The training itself is free — the certificate carries an optional ₦5,000 processing fee, only for those who want the physical/digital certificate issued.
Registration
Registration, pricing, and exact dates are on the Programs page.
Register for the Excel Cohort →