Data Analysis with Excel and Power Bi

COURSE OVERVIEW

If your reports take too long to prepare, feel unclear, or fail to influence decisions, this course is for you.

Data Analysis with Excel & Power BI is a hands-on training that equips professionals with the skills to turn raw data into clear dashboards and executive-ready reports. The program focuses on real workplace use cases, not theory ensuring participants can apply what they learn immediately.

This course is ideal for professionals who work with data and want to improve speed, accuracy, and confidence in reporting.

WHAT YOU WILL LEARN

By the end of this program, you will be able to:

• Clean, structure, and analyze data using Excel

• Use formulas, PivotTables, and dashboards for reporting

• Build interactive dashboards using Excel and Power BI

• Translate data insights into clear PowerPoint presentations

• Communicate insights confidently to managers and executives

CURRICULUM

Day 1: Excel Foundations for Data Analysis

• Data structure, data hygiene, and reporting best practices

• Excel tables, sorting, filtering, and data cleaning

• Core Excel functions for analysis

• Introduction to PivotTables

Day 2: Advanced Excel Dashboards & Reporting

• Advanced lookups and formulas

• Conditional formatting and data validation

• Dashboard design principles and KPIs

• Business reporting use cases

Day 3: Power BI Integration & Dashboards

• Connecting Excel data to Power BI

• Data transformation with Power Query

• Data modeling fundamentals

• Building interactive Power BI dashboards

Day 4: Executive Reporting & Presentation

• Analytics storytelling for decision-making

• Exporting visuals from Excel and Power BI

• Creating executive-ready PowerPoint reports

• Mini capstone presentation and feedback

WHO THIS COURSE IS FOR

• HR professionals

• Finance and accounting professionals

• Operations and admin professionals

• Team leads and managers

• Anyone responsible for reporting, dashboards, or KPIs

Level: Beginner – Intermediate

COURSE DETAILS

• Mode: Virtual (Live sessions)

• Dates: March 14, 15, 21 & 22, 2026

• Time:

  • Saturdays: 10:00am – 1:00pm

  • Sundays: 2:00pm – 5:00pm

• Duration: 4 sessions (4 hours per session)

WHAT YOU GET

• Live, instructor-led sessions

• Lifetime access to class recordings

• Practice datasets and dashboard templates

• PowerPoint reporting templates

• Certificate of completion

Fee:

• Standard Fee: ₦70,000 

Group Discount:
Organizations enrolling 5 participants or more receive a 10% discount (up to 25 participants).

💳 Payment Options

Participants may choose from the following payment options:
• Standard – ₦70,000 (one-time payment)
• Installment Plan – ₦38,000 deposit
(Balance of ₦38,000 due on or before March 13, 2026)

Please note:
• Installment plan is based on the standard fee, not early bird
• Initial deposit is non-refundable
• Full payment is required to access live classes, recordings, templates, and certification

IMPORTANT NOTE

This is a hands-on program. Participants will complete short assignments and practical exercises to reinforce learning and build real skill.