Excel & Power BI for Data Analysis
Business analysts, accountants, finance professionals, operations staff, administrators, and anyone who works with data regularly but wants to extract more value from it
₦250000.00₦220000.00
Course Structure
Duration: 2 Weeks
Format: Cohort
Labs: 10 Hands-On Dashboard Labs
Projects: 2 — Excel Analytical Report + Power BI Business Dashboard
Theory vs Practical: 30% / 70%
What Participants Will Learn
Advanced Excel: VLOOKUP, INDEX-MATCH, pivot tables, dynamic arrays, and data cleaning
Excel data modelling and building automated dashboards
Introduction to Power BI: the interface, data sources, and core concepts
Connecting Power BI to Excel, SQL databases, and cloud data sources
Building interactive reports, charts, slicers, and drill-down dashboards
DAX (Data Analysis Expressions) fundamentals for calculated fields and measures
Storytelling with data: choosing the right chart for the right message
Publishing and sharing reports with stakeholders
Description
Data is everywhere — the question is whether you can read it, interpret it, and present it compellingly. This course transforms participants from spreadsheet users into confident data analysts, combining the familiarity of Excel with the power of Power BI to turn raw numbers into actionable business insights.