Excel for Data Analysts
Learn to clean, analyse, and present data like a professional analyst.
Have questions? Chat with Isaac on WhatsApp →
Curriculum
What You'll Learn
8 sections built around a real pharmaceutical sales dataset. Every skill is practised in context — not in isolation.
Getting Started
Course overview, expectations, and introduction to the real-world dataset you'll work with throughout.
Working with Data
How to structure, sort, filter, and clean messy data — handling blanks, duplicates, inconsistent text, and formatting issues.
Formulas That Analysts Actually Use
Core calculations, logical decision-making in spreadsheets, handling errors gracefully, and working with dates.
Connecting Tables — Lookups
How to pull related information from different tables into one view — the foundation for working with multi-table data.
Power Query — The Analyst's Data Pipeline
Importing data from multiple sources, cleaning and transforming it, merging tables, and building automated, refreshable data pipelines.
Answering Business Questions
Conditional summaries, pivot tables, and exploratory data analysis — turning raw data into answers.
Visual Communication
Formatting for clarity, choosing the right chart, building dashboards, and preparing your work for presentation.
Capstone Project
Build a Quarterly Business Review for a Regional Sales Manager — full analysis, dashboard, and executive summary.
Getting Started
Course overview, expectations, and introduction to the real-world dataset you'll work with throughout.
Working with Data
How to structure, sort, filter, and clean messy data — handling blanks, duplicates, inconsistent text, and formatting issues.
Formulas That Analysts Actually Use
Core calculations, logical decision-making in spreadsheets, handling errors gracefully, and working with dates.
Connecting Tables — Lookups
How to pull related information from different tables into one view — the foundation for working with multi-table data.
Power Query — The Analyst's Data Pipeline
Importing data from multiple sources, cleaning and transforming it, merging tables, and building automated, refreshable data pipelines.
Answering Business Questions
Conditional summaries, pivot tables, and exploratory data analysis — turning raw data into answers.
Visual Communication
Formatting for clarity, choosing the right chart, building dashboards, and preparing your work for presentation.
Capstone Project
Build a Quarterly Business Review for a Regional Sales Manager — full analysis, dashboard, and executive summary.
Next cohort is small. Spots fill fast.
Included Free
The Data Analyst Mindset
“You don't just learn Excel — you learn to think and communicate like an analyst.”
Most Data Analytics courses stop at the tool. This add-on course runs alongside your Excel training and builds the professional skills that make your analysis actually land — with stakeholders, with managers, with anyone reading your work.
Get this free when you enrol →What's covered
Data Foundations
How data works, types, and structures.
Analytical Thinking
Frameworks for breaking down business problems.
Communication & Storytelling
Presenting findings that drive decisions.
Data Visualisation Principles
What makes a chart effective.
Professional & Stakeholder Skills
Working with teams and managing expectations.
The Data Analyst Mindset curriculum grows as you progress through the path — deeper analytical frameworks, Cybersecurity Essentials, and more are woven into the SQL and Power BI courses.
Pricing
What You're Investing In
A small cohort. A real dataset. A portfolio project you can show at your next interview.
Who this is for
- You want to move into a data analytics role
- You already know basic Excel — this course builds on that
- You want structured learning with a real instructor, not YouTube
- You can commit ~5–6 hours a week — 3 hrs of live sessions + 2–3 hrs of assignments
Everything that's included
- 20 live instructor-led sessions
- Real sales datasets
- Assignments & lab practice between sessions
- Portfolio-ready Quarterly Business Review capstone
- The Data Analyst Mindset programme (free)
- CV & LinkedIn profile review after the capstone
- Certificate of completion
- Excel 365 licence available at small fee if needed
Cohort price
per person · cohort of 2–5 students
Maximum 5 students per cohort to maintain mentoring quality. Once it's full, the next cohort opens to the waitlist first.
Flexible payment plans available — reach out to discuss.
Why It Works
The Format That Gets Results
Most people don't finish online courses. Here's why this one is different.
Ask questions when you're stuck — not 3 days later
Two live sessions a week means you never sit with a blocker for long. Isaac is there to answer in real time, spot your mistakes, and explain the 'why' — not just the steps.
One dataset. Ten weeks. Skills that actually connect.
You work on the same real pharmaceutical sales dataset from session one to the capstone. Every new skill builds on the last — so nothing feels random or disconnected.
Practice within 24 hours, or it doesn't stick
Short assignments after each session make sure the skill moves from 'I understand it' to 'I can do it'. That gap is why most online courses don't work.
A cohort small enough that Isaac knows your name
Maximum 5 students. If you're lost, he notices before you have to say anything. You don't fall through the cracks — because there are no cracks in a group this size.
Part of a Bigger Journey
The Data Analyst Path
SQL, Excel, and Power BI appear in more data analyst job postings than any other combination. But the goal isn't just the tools — it's becoming tool agnostic. Master the thinking here and it transfers wherever the work takes you.
Excel for Data Analytics
SQL for Business Analysis
Power BI for Reporting & Dashboards
Bundle pricing and flexible payment plans are available when enrolling in multiple path courses. Reach out to discuss.
* Based on an analysis of 1,964 LinkedIn data analyst job postings (2024) and 365 Data Science career outlook data.
Your Move
Ready to Think Like an Analyst? Start with Excel.
The next cohort starts 1 April 2026. Small cohort — once it's full, it's full.
GHS 2,400 · Cohort of 2–5 · Flexible payment plans available