Free masterclass · Excel · Live online
Raw data in.Insights out.
Excel for Data Analysis: from raw data to business insights
Turn a messy retail sales file into a working business dashboard, live, in three hours.
- When
- Saturday 28 November 2026
- 6:00 – 9:00 PM WAT · 3 hours
- Where
- Google Meet
- Free setup clinic from 5:00 PM WAT
Taught by Segun Umoru · Data Analytics Trainer and AI/ML Engineer
₦48.2M
Revenue
3,420
Orders
+18%
Growth
What you will learn
From a messy file to a finished dashboard.
Beginner-friendly and hands-on. You work alongside Segun on a real business dataset, not slides.
- Understand the role of Excel in the data analytics workflow.
- Import, clean and prepare messy datasets.
- Apply IF, SUMIFS, COUNTIFS, XLOOKUP and TEXT functions with confidence.
- Use sorting, filtering, conditional formatting and data validation.
- Explore data with PivotTables and PivotCharts.
- Build an interactive Excel dashboard.
- Interpret your findings and communicate business insights.
The programme
Three hours, minute by minute.
Saturday 28 November 2026. All times are Lagos time (WAT).
5:00 – 6:00 PM
Free setup clinic
Optional. Help installing and opening everything you need, on the same link.
6:00 – 6:15 PM
Introduction
What is data analytics? The analytics workflow and Excel's role.
6:15 – 6:35 PM
Data fundamentals
Datasets, data types and data quality.
6:35 – 7:05 PM
Data cleaning
Duplicates, missing values, formatting and inconsistencies.
7:05 – 7:35 PM
Excel formulas
SUM, AVERAGE, COUNT, IF, SUMIFS, COUNTIFS and XLOOKUP.
7:35 – 7:45 PM
Break
Questions and refreshments.
7:45 – 8:15 PM
Data analysis
Sorting, filtering, PivotTables and PivotCharts.
8:15 – 8:45 PM
Dashboard development
KPIs, charts and dashboard layout.
8:45 – 9:00 PM
Project presentation
Insights, questions and next steps.
The practical project
Retail Sales Performance Analysis
You receive a retail sales dataset and work through it with Segun, step by step, to answer the questions a manager would ask.
You leave with a finished Excel sales performance dashboard, built from a real-world business dataset, that you can show as your first portfolio piece.
Questions you will answer
- 1What is the total revenue generated?
- 2Which products generate the most revenue?
- 3Which regions have the highest sales?
- 4What are the monthly sales trends?
- 5Which product categories perform poorly?
- 6What recommendations can management make?
Before you join
What to have ready.
Not sure about something? The free setup clinic runs from 5:00 to 6:00 PM WAT, an hour before the class, on the same link.
A laptop
Windows or Mac. A phone or tablet is not enough for the practical work.
Microsoft Excel, 2021 or Microsoft 365
XLOOKUP only exists in Excel 2021 and Microsoft 365. Older versions can still follow most of the class. Excel for the web is free with a Microsoft account and also works.
Google Meet and a stable connection
Join from a laptop browser so you can share your screen if you need help. Earphones help.
The practice file
Emailed to registered attendees before the class. Download it and open it at the setup clinic to check it works.
Certificate of participation
Finish, and it is yours.
Attend at least 2 of the 3 hours live and complete the practical project.
After the class we email you a personal link. Type your full name, exactly as you want it printed, and download your certificate on the spot.
Register
Reserve your free seat.
Excel for Data Analysis · Saturday 28 November 2026 · 6:00 – 9:00 PM WAT. Seats are limited so the class stays interactive. Your joining link is emailed the moment you register.
Your local time
| City | Setup clinic | Class |
|---|---|---|
| Lagos | 5:00 pm | 6:00 pm – 9:00 pm |
| London | 4:00 pm | 5:00 pm – 8:00 pm |
| Dubai | 8:00 pm | 9:00 pm – 12:00 am |
| New York | 11:00 am | 12:00 pm – 3:00 pm |
| Los Angeles | 8:00 am | 9:00 am – 12:00 pm |
Share it with someone who needs it
Questions
Good to know.
My Excel does not have XLOOKUP. Can I still attend?
Yes. Come to the setup clinic at 5:00 PM and we will get you onto Excel for the web, which is free and has XLOOKUP. You can also follow the rest of the class on any version.
Is it really free?
Yes. Registration, the live class, the practice files and the certificate are all free. You need a laptop and a stable internet connection.
Do I need any experience?
No. Both sessions start from the beginning and are built for graduates, working professionals and career switchers who want a first real taste of data analytics.
Where does it hold, and how do I join?
Online, on Google Meet. Register and the joining link is emailed to you straight away, then repeated in the reminder emails a week before, the day before and on the morning of the class.
What is the setup clinic?
A free hour before each class, 5:00 to 6:00 PM WAT, on the same Meet link. Come early if you want help installing or opening what you need, so the three hours of class are spent learning and not troubleshooting.
Will there be a recording?
The class is taught live and the practical work is done together, so attending live is how you get the most from it. Do not plan to watch later.
How do I get the certificate?
Attend at least two of the three hours live and complete the practical project. After the class we email you a personal link. Type your full name there and download your certificate of participation straight away.
What happens if the class is full?
Seats are limited to keep the class interactive. Once the cap is reached registration closes, so register early and join a few minutes before the start.
Also free
SQL for Data Analytics, Saturday 12 December 2026
Learn to ask a database real business questions and get answers back, from your first SELECT to JOINs.
Powered by Blagetech Labs Ltd.