About This Programme
A focused, practical introduction to data analytics. In six weeks you will gain hands-on skills in Microsoft Excel and Power BI — the two most in-demand data tools in Nigerian and international organisations. By the end you will be able to clean, analyse, and visualise data, and you will leave with a CPD-certified certificate.
Flexible payment: spread the cost — contact us for details.
What's Included
- ✓Microsoft Excel fundamentals and advanced functions (VLOOKUP, IF, COUNTIF, INDEX/MATCH)
- ✓Data cleaning and preparation — removing errors, handling duplicates, structuring data
- ✓PivotTables, PivotCharts and Excel dashboards
- ✓Introduction to Power BI — connecting data sources and building reports
- ✓Power Query for data transformation and automation
- ✓Building interactive Power BI dashboards
- ✓Data storytelling — presenting insights clearly to non-technical audiences
- ✓Real-world datasets used throughout — practice on data you will see in the workplace
- ✓Live instructor-led sessions via Microsoft Teams (recordings included)
- ✓CPD-certified completion certificate
Programme Modules
1
Week 1 — Introduction to Data Analytics & Excel Fundamentals
- What data analytics is and why it matters
- Navigating Excel: workbooks, worksheets, and the ribbon
- Data types, formatting, and basic formulas (SUM, AVERAGE, COUNT)
- Sorting and filtering data
- Introduction to tables in Excel
2
Week 2 — Advanced Excel for Data Analysis
- Logical functions: IF, AND, OR, nested IF statements
- Lookup functions: VLOOKUP, HLOOKUP, INDEX and MATCH
- Statistical and text functions
- Named ranges and data validation
- Conditional formatting to highlight key data
3
Week 3 — Data Cleaning & Data Quality
- Identifying and handling missing values and duplicates
- Standardising inconsistent data (dates, names, formats)
- Using Flash Fill and Text to Columns
- Introduction to Power Query for automated data cleaning
- Building a repeatable data cleaning workflow
4
Week 4 — PivotTables, Charts & Excel Dashboards
- Creating and customising PivotTables
- PivotCharts — bar, line, pie and combo charts
- Slicers and timeline filters for interactive reports
- Building a one-page Excel dashboard
- Best practices for presenting data visually
5
Week 5 — Introduction to Power BI
- Installing and navigating Power BI Desktop
- Connecting to Excel, CSV and online data sources
- Power Query in Power BI — transforming and shaping data
- Building your first report: cards, bar charts, tables
- Publishing to Power BI Service and sharing reports
6
Week 6 — Power BI Dashboards & Capstone Project
- Advanced visuals: maps, KPI cards, slicers and drill-through
- Introduction to DAX: basic calculated columns and measures
- Building an interactive multi-page Power BI dashboard
- Capstone project: analyse a real dataset end-to-end
- CPD assessment and certificate submission
Ready to enrol?
Submit an enquiry and an advisor will call you within 24 hours, or pay online to secure your place immediately.
₦110,000one-time fee
Enrol Now