All coursesTURN DATA INTO A CLEAR DECISION

Data Analysis with Excel.

Clean a fictional sales dataset, build reliable formulas and PivotTables, and present a dashboard with findings you can defend.

12 detailed lessons6 module quizzesFinal project + certificate

Use a suitable computer and Excel for the web or a compatible current Excel version. Software subscriptions are separate. The browser studio teaches analysis logic; it is not a full Excel editor. This is not a Microsoft-issued qualification.

₦12,000One payment.
Ongoing course access.

Try the free lesson

Secure checkout through Paystack · No subscription

Data Analysis with Excel: a practical path from foundations to final project

Clean a fictional sales dataset, build reliable formulas and PivotTables, and present a dashboard with findings you can defend. Study twelve chapters in six modules, practise each technique and submit a coherent project for human review.

What you’ll be able to do

Clean and validate a business dataset
Use formulas, conditional totals and key-based lookups
Build and reconcile PivotTables and clear charts
Explain findings, assumptions and limitations in a reviewable workbook

YOUR STEP-BY-STEP ROADMAP

Inside the course

6 modules · 12 lessons · 6 quizzes

Start with purpose

Questions and trustworthy data

2 chapters · Practice exercises · Module quiz

Ask a question a dataset can answer9 min read · 40 min practiceFree preview

Organise a workbook without damaging the source9 min read · 40 min practice

Check your understandingQuiz · 70% to pass

Build reliable foundations

Cleaning and validation

2 chapters · Practice exercises · Module quiz

Clean text and missing values deliberately9 min read · 40 min practice

Find duplicates and reconcile totals9 min read · 40 min practice

Check your understandingQuiz · 70% to pass

Apply the method

Formulas and lookups

2 chapters · Practice exercises · Module quiz

Build formulas and understand cell references9 min read · 40 min practice

Summarise with conditions and look up categories9 min read · 40 min practice

Check your understandingQuiz · 70% to pass

Connect the pieces

Summaries and honest charts

2 chapters · Practice exercises · Module quiz

Create and validate a PivotTable9 min read · 40 min practice

Choose a chart that supports comparison9 min read · 40 min practice

Check your understandingQuiz · 70% to pass

Test and improve

Dashboards and reasoning

2 chapters · Practice exercises · Module quiz

Build a focused dashboard9 min read · 55 min practice

Check conclusions and quantify uncertainty9 min read · 55 min practice

Check your understandingQuiz · 70% to pass

Deliver your project

Analysis handoff and capstone

2 chapters · Practice exercises · Module quiz

Prepare a reproducible analysis handoff9 min read · 55 min practice

Complete the retail analysis capstone9 min read · 55 min practice

Check your understandingQuiz · 70% to pass

PUT YOUR KNOWLEDGE TO WORK

Your final project

Analyse a fictional retailer’s sales in a reviewable Excel workbook: raw and cleaned data, quality log, formulas, lookup, validated PivotTable, dashboard and a three-finding memo with limitations.

Submit your project link and a reflection after completing the lessons and quizzes. An administrator reviews your work and provides feedback before your certificate is unlocked.

BEFORE YOU ENROL

Course questions, answered

How much does this course cost?

₦12,000 as a one-time payment, with no recurring course subscription.

What will I create?

Analyse a fictional retailer’s sales in a reviewable Excel workbook: raw and cleaned data, quality log, formulas, lookup, validated PivotTable, dashboard and a three-finding memo with limitations.

What tools do I need?

Use a suitable computer and Excel for the web or a compatible current Excel version. Software subscriptions are separate. The browser studio teaches analysis logic; it is not a full Excel editor. This is not a Microsoft-issued qualification.

How will I learn and practise?

Each chapter includes concept notes, worked evidence, a guided lab, retrieval checks and a practical task. The interactive studio demonstrates course-specific decisions; complete the final artefacts in the appropriate external tool.

How do I earn the certificate?

Complete all twelve chapters, pass each of six module quizzes with at least 70% and receive administrator approval on your final project. Certificates recognise academy completion, without external accreditation or employment guarantees.

Explore another path: Web Development · Cybersecurity Foundations · Software Engineering · Graphic Design with Canva · UI/UX Design with Figma · Digital Marketing · Project Management ·