Skip to content
Segun UmoruSEGUN UMORU

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

fx=INSIGHTS(raw_data)

₦48.2M

Revenue

3,420

Orders

+18%

Growth

Sample · you build this live

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).

  1. 5:00 – 6:00 PM

    Free setup clinic

    Optional. Help installing and opening everything you need, on the same link.

  2. 6:00 – 6:15 PM

    Introduction

    What is data analytics? The analytics workflow and Excel's role.

  3. 6:15 – 6:35 PM

    Data fundamentals

    Datasets, data types and data quality.

  4. 6:35 – 7:05 PM

    Data cleaning

    Duplicates, missing values, formatting and inconsistencies.

  5. 7:05 – 7:35 PM

    Excel formulas

    SUM, AVERAGE, COUNT, IF, SUMIFS, COUNTIFS and XLOOKUP.

  6. 7:35 – 7:45 PM

    Break

    Questions and refreshments.

  7. 7:45 – 8:15 PM

    Data analysis

    Sorting, filtering, PivotTables and PivotCharts.

  8. 8:15 – 8:45 PM

    Dashboard development

    KPIs, charts and dashboard layout.

  9. 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

  1. 1What is the total revenue generated?
  2. 2Which products generate the most revenue?
  3. 3Which regions have the highest sales?
  4. 4What are the monthly sales trends?
  5. 5Which product categories perform poorly?
  6. 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

Class and setup clinic start times in five cities
CitySetup clinicClass
Lagos5:00 pm6:00 pm – 9:00 pm
London4:00 pm5:00 pm – 8:00 pm
Dubai8:00 pm9:00 pm – 12:00 am
New York11:00 am12:00 pm – 3:00 pm
Los Angeles8:00 am9:00 am – 12:00 pm

Share it with someone who needs it

Free, live, online

Reserve your seat

FREE

Your confirmation and joining details are sent to your email. No spam.

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.