Transform Data into Business Intelligence with Microsoft Excel
A progressive, expert-led suite of data analysis programmes – from Foundation Diploma to Advanced Professional Diploma. 100% online, hands-on projects, and real-world business applications. Master formulas, Pivot Tables, Power Query, dashboards, Macros, and business intelligence with Microsoft Excel.
Designed for Data Analysis Excellence in Excel
Practical, project-based, and globally relevant – build a portfolio of dashboards and reports while you learn from industry experts.
Transform Data into Intelligence
Learn how to convert raw data into meaningful insights that support smarter business decisions.
Industry-Focused Curriculum
Master the Excel tools and techniques used by analysts, accountants, managers, and business executives worldwide.
Three Progressive Levels
Advance from Foundation to Professional and Advanced Professional Diploma, building your expertise step by step.
Learn by Doing
Complete practical exercises, real-world case studies, dashboards, and business projects throughout the programme.
Build Interactive Dashboards
Create professional KPI dashboards and reports that present complex business data clearly and effectively.
Real Business Case Studies
Work with datasets from sales, finance, inventory, HR, healthcare, education, and marketing.
No Programming Required
Start as a beginner and progressively develop advanced data analysis skills using Microsoft Excel.
Hands-On Capstone Projects
Graduate with a portfolio of practical Excel projects that demonstrate your analytical skills to employers.
Learn Data Cleaning & Transformation
Prepare, clean, merge, and organise datasets for accurate reporting and business analysis.
Automate Repetitive Tasks
Use Excel Macros and VBA fundamentals to increase productivity and reduce manual work.
Career-Focused Skills
Develop skills relevant to Data Analyst, Business Analyst, Financial Analyst, Operations Analyst, HR Analyst, and more.
Industry-Recognised Certification
Earn a verified diploma upon successful completion – blockchain-secured, globally recognised.
Foundation Diploma in Data Analysis in Excel
Build a strong foundation in Microsoft Excel. Master the interface, basic formulas, cell references, text and date functions, data validation, sorting, filtering, conditional formatting, tables, charts, and introductory Pivot Tables. Perfect for beginners with no prior Excel experience.
Excel Setup, UI, Data Types, Basic Formulas
Get started with Microsoft Excel by learning the interface, worksheets, data types, and essential formulas.
- Unit 1: Microsoft Excel Interface and Workbook Setup
- Unit 2: Worksheets, Rows, Columns, and Cells
- Unit 3: Data Types and Cell Formatting
- Unit 4: Basic Excel Formulas and Operators
- Unit 5: Using SUM, AVERAGE, COUNT, MAX, and MIN Functions
- Unit 6: Creating and Formatting Simple Worksheets
Cell References, Text Functions, Date Functions, Data Validation
Master cell referencing, text and date functions, logical functions, and data validation for accurate data entry.
- Unit 1: Relative, Absolute, and Mixed Cell References
- Unit 2: Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)
- Unit 3: Date and Time Functions
- Unit 4: Logical Functions (IF, AND, OR)
- Unit 5: Data Validation and Drop-Down Lists
- Unit 6: Practical Data Entry and Validation Exercises
Sorting, Filtering, Conditional Formatting, Tables
Learn to organise, clean, and manage business data efficiently using sorting, filtering, conditional formatting, and Excel tables.
- Unit 1: Sorting Data
- Unit 2: Filtering and Advanced Filtering
- Unit 3: Conditional Formatting Rules
- Unit 4: Creating and Managing Excel Tables
- Unit 5: Removing Duplicates and Data Cleaning
- Unit 6: Organising Business Data Efficiently
Charts Basics, Pivot Table Intro, Project: Sales Dashboard
Create and format charts, explore Pivot Tables, and build an interactive sales dashboard as your final project.
- Unit 1: Creating and Formatting Charts
- Unit 2: Selecting Appropriate Chart Types
- Unit 3: Introduction to Pivot Tables
- Unit 4: Summarising Data with Pivot Tables
- Unit 5: Creating Interactive Sales Dashboards
- Unit 6: Final Project: Sales Dashboard Development
Upon completion, earn a verified Foundation Diploma in Data Analysis in Excel – blockchain‑secured, globally recognised.
Professional Diploma in Data Analysis in Excel
Take your Excel skills to the next level. Master advanced lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH), deep-dive into Pivot Tables with slicers and calculated fields, clean and transform data, and build professional KPI dashboards.
Advanced Formulas: VLOOKUP, XLOOKUP, INDEX-MATCH
Master advanced lookup functions to retrieve and combine data from multiple sources for comprehensive reporting.
- Unit 1: Advanced Lookup Functions
- Unit 2: Using VLOOKUP for Data Retrieval
- Unit 3: Using XLOOKUP for Dynamic Searches
- Unit 4: INDEX and MATCH Functions
- Unit 5: Nested and Combined Formulas
- Unit 6: Practical Lookup and Reporting Exercises
Pivot Tables Deep Dive, Slicers, Calculated Fields
Go beyond basic Pivot Tables. Learn advanced techniques, slicers, timelines, calculated fields, and interactive business reporting.
- Unit 1: Advanced Pivot Table Techniques
- Unit 2: Creating and Customizing Pivot Charts
- Unit 3: Using Slicers and Timelines
- Unit 4: Calculated Fields and Calculated Items
- Unit 5: Grouping, Sorting, and Filtering Pivot Data
- Unit 6: Interactive Business Reporting
Data Cleaning, Text to Columns, Remove Duplicates
Master essential data cleaning techniques to prepare messy data for accurate analysis and reporting.
- Unit 1: Data Cleaning Techniques
- Unit 2: Text to Columns
- Unit 3: Flash Fill and Find & Replace
- Unit 4: Removing Duplicates
- Unit 5: Handling Missing and Inconsistent Data
- Unit 6: Preparing Data for Analysis
Project: KPI Dashboard with Charts + Pivot
Design and build an interactive KPI dashboard integrating Pivot Tables and charts for executive-level reporting.
- Unit 1: Key Performance Indicator (KPI) Design
- Unit 2: Advanced Chart Creation and Formatting
- Unit 3: Building Interactive Dashboards
- Unit 4: Integrating Pivot Tables with Charts
- Unit 5: Dashboard Automation and Best Practices
- Unit 6: Final Project: KPI Dashboard Development
Upon completion, earn a verified Professional Diploma in Data Analysis in Excel – blockchain‑secured, globally recognised.
Advanced Professional Diploma in Data Analysis in Excel
Reach expert-level proficiency in Microsoft Excel. Master Power Query for automated data preparation, advanced conditional functions (SUMIFS, COUNTIFS), dynamic array formulas, Macros and VBA automation, and deliver an end-to-end business report capstone project.
Power Query Intro, Data Import, Merge, Append
Transform your data preparation workflow with Power Query. Import, merge, append, and automate data cleaning from multiple sources.
- Unit 1: Introduction to Power Query
- Unit 2: Importing Data from Multiple Sources
- Unit 3: Transforming and Cleaning Data
- Unit 4: Merging Queries
- Unit 5: Appending Queries
- Unit 6: Building Automated Data Preparation Workflows
Advanced Functions: SUMIFS, COUNTIFS, Array Formulas
Solve complex business analysis problems with advanced conditional functions, dynamic arrays, and nested formulas.
- Unit 1: SUMIFS Function
- Unit 2: COUNTIFS Function
- Unit 3: AVERAGEIFS and Related Functions
- Unit 4: Dynamic Array Formulas
- Unit 5: Advanced Logical and Nested Functions
- Unit 6: Solving Complex Business Analysis Problems
Macros & Automation Basics
Learn to automate repetitive tasks using Excel Macros, VBA Editor, and simple VBA procedures to increase productivity.
- Unit 1: Introduction to Excel Macros
- Unit 2: Recording and Running Macros
- Unit 3: Editing Macros with VBA Editor
- Unit 4: Automating Repetitive Tasks
- Unit 5: Creating Simple VBA Procedures
- Unit 6: Practical Excel Automation Project
Capstone: End-to-End Business Report
Integrate all your Excel skills to deliver a complete end-to-end business report. Analyse real-world data, build dashboards, and present actionable insights.
- Unit 1: Business Problem Analysis
- Unit 2: Data Collection and Preparation
- Unit 3: Data Analysis and Visualization
- Unit 4: Dashboard and Report Development
- Unit 5: Presenting Business Insights and Recommendations
- Unit 6: Final Capstone Project: End-to-End Business Report
Upon completion, earn a verified Advanced Professional Diploma in Data Analysis in Excel – blockchain‑secured, globally recognised.
Roles You Can Pursue with Excel Data Analysis Skills
Develop practical, job-ready Excel skills that are highly sought after across business, finance, healthcare, education, government, and nonprofit sectors.
What Excel Data Analysis Graduates Say
"The Foundation Diploma transformed my understanding of Excel. I now create dashboards for my department with confidence."
— Emeka U., Nigeria
"The Professional Diploma took my reporting skills to the next level. The Pivot Tables and dashboard modules were game-changers."
— Judith 0., Kenya
"The Advanced Professional Diploma prepared me for senior analyst roles. Power Query and Macros automation have saved me hours of manual work."
— Susan M., South Africa
Affordable Tuition for Local & International Students
All inclusive: tuition + application fee. Flexible interest‑free instalments available.
Application fee ₦8,220 is included in the total above.
Application fee ₦8,220 is included in the total above.
Transform Data into Business Intelligence with Excel
Choose your level – Foundation, Professional, or Advanced Professional Diploma. Build real-world dashboards, earn verifiable credentials, and advance your career in data analysis.
Questions About Our Data Analysis Programmes?
Our admissions team is ready to discuss prerequisites, curriculum, and which programme fits your career goals.
WhatsApp Us Email Enquiry