Certification Course
Beginner to intermediate track covering Advanced Excel, Power BI, and SQL. Build strong foundations through hands-on projects and real-world insights.
ALPHA-DATA PROGRAM
₦50k
FEATURES:
Advanced Excel
Advanced PowerBI
SQL
Project Portfolio
5 Interview Preparation Sessions
Learning Schema
Week 1: Excel Basics & Referencing (Case Study-Based)
Session 1
- Introduction to Excel: Interface, workbook vs. worksheet
- Understanding rows, columns, cells, and ranges
- Formatting basics: numbers, text, dates, and conditional formatting
Session 2
- Cell referencing: Relative, Absolute, and Mixed
- Basic functions: SUM, AVERAGE, MIN, MAX, IF
- Case Study Exercise: Simple budget tracker or attendance sheet
Week 2: Intermediate Excel – Tables to Dashboards
Session 1
- Excel Tables & Structured Referencing
- Lookup functions: VLOOKUP, XLOOKUP (optional), INDEX MATCH
- Data cleaning basics: Remove duplicates, trim, split text, etc
Session 2
- Pivot Tables & Pivot Charts
- Building Excel Dashboards
- Case Study Exercise: Sales dashboard or employee performance report
Week 3: Power BI Essentials
Session 1
- Introduction to Power BI Interface
- Connecting to data sources (Excel, CSV)
- Data cleaning using Power Query Editor
Week 4: Modelling & Dashboarding
Session 1
- Creating calculated columns and measures (DAX intro)
- Filtering and slicers
- Card and KPI visuals
Week 5: SQL Fundamentals
Session 1
- Introduction to SQL & DBMS
- Data types, tables, and schemas
- Writing basic queries: SELECT, WHERE, ORDER BY
Session 2
- Filtering with AND, OR, IN, BETWEEN, LIKE
- Sorting & limiting results
- Case Study Exercise: Querying a sales database
Week 6: Joins, Aggregates & Subqueries
Session 2
- Joins: INNER, LEFT, RIGHT, FULL
- Subqueries and nested queries
- Case Study: Customer order analysis
