Master Data Analysis with Excel, Python & R
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. Choose your track: Microsoft Excel, Python, or R Programming.
Designed for Data Analysis Excellence
Practical, project-based, and globally relevant – build a portfolio of dashboards, reports, and analyses while you learn from industry experts.
Master Excel for Business
Learn formulas, Pivot Tables, Power Query, dashboards, and automation for business intelligence.
Python for Data Analysis
Master Pandas, NumPy, data visualization, statistics, and automation with Python.
R for Statistical Analysis
Learn dplyr, ggplot2, R Markdown, Shiny, and statistical modeling with R.
Three Progressive Levels
Advance from Foundation to Professional and Advanced Professional Diploma in each track.
Learn by Doing
Complete practical exercises, real-world case studies, dashboards, and projects.
Build Interactive Dashboards
Create professional KPI dashboards and reports that present complex business data clearly.
Real Business Case Studies
Work with datasets from sales, finance, HR, healthcare, education, and marketing.
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.
- Microsoft Excel Interface and Workbook Setup
- Worksheets, Rows, Columns, and Cells
- Data Types and Cell Formatting
- Basic Excel Formulas and Operators
- Using SUM, AVERAGE, COUNT, MAX, and MIN Functions
- 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.
- Relative, Absolute, and Mixed Cell References
- Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)
- Date and Time Functions
- Logical Functions (IF, AND, OR)
- Data Validation and Drop-Down Lists
- 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.
- Sorting Data
- Filtering and Advanced Filtering
- Conditional Formatting Rules
- Creating and Managing Excel Tables
- Removing Duplicates and Data Cleaning
- 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.
- Creating and Formatting Charts
- Selecting Appropriate Chart Types
- Introduction to Pivot Tables
- Summarising Data with Pivot Tables
- Creating Interactive Sales Dashboards
- 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.
- Advanced Lookup Functions
- Using VLOOKUP for Data Retrieval
- Using XLOOKUP for Dynamic Searches
- INDEX and MATCH Functions
- Nested and Combined Formulas
- 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.
- Advanced Pivot Table Techniques
- Creating and Customizing Pivot Charts
- Using Slicers and Timelines
- Calculated Fields and Calculated Items
- Grouping, Sorting, and Filtering Pivot Data
- Interactive Business Reporting
Data Cleaning, Text to Columns, Remove Duplicates
Master essential data cleaning techniques to prepare messy data for accurate analysis and reporting.
- Data Cleaning Techniques
- Text to Columns
- Flash Fill and Find & Replace
- Removing Duplicates
- Handling Missing and Inconsistent Data
- 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.
- Key Performance Indicator (KPI) Design
- Advanced Chart Creation and Formatting
- Building Interactive Dashboards
- Integrating Pivot Tables with Charts
- Dashboard Automation and Best Practices
- 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.
- Introduction to Power Query
- Importing Data from Multiple Sources
- Transforming and Cleaning Data
- Merging Queries
- Appending Queries
- 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.
- SUMIFS Function
- COUNTIFS Function
- AVERAGEIFS and Related Functions
- Dynamic Array Formulas
- Advanced Logical and Nested Functions
- 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.
- Introduction to Excel Macros
- Recording and Running Macros
- Editing Macros with VBA Editor
- Automating Repetitive Tasks
- Creating Simple VBA Procedures
- 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.
- Business Problem Analysis
- Data Collection and Preparation
- Data Analysis and Visualization
- Dashboard and Report Development
- Presenting Business Insights and Recommendations
- 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.
Foundation Diploma in Data Analysis Using Python
Build a strong foundation in Python programming for data analysis. Master Python setup, variables, data types, control flow, functions, lists, dictionaries, NumPy arrays, and Pandas DataFrames.
Python Setup, Jupyter, Variables, Data Types
- Installing Python and Jupyter Notebook
- Python Syntax and Code Structure
- Variables and Data Types
- Input and Output Operations
- Operators and Expressions
- Writing Your First Python Programs
Control Flow, Functions, Lists, Dictionaries
- Conditional Statements (If, Else, Elif)
- Loops (For and While)
- Functions and Parameters
- Lists and List Operations
- Dictionaries and Dictionary Methods
- Practical Python Programming Exercises
NumPy Basics, Arrays, Operations
- Introduction to NumPy
- Creating and Managing Arrays
- Array Indexing and Slicing
- Mathematical Operations on Arrays
- Statistical Functions in NumPy
- Practical Numerical Computing Exercises
Pandas Intro: DataFrames, Reading CSV, Basic Ops
- Introduction to Pandas
- Series and DataFrames
- Importing Data from CSV Files
- Data Selection and Filtering
- Basic Data Manipulation
- Exploring Real-World Datasets
Upon completion, earn a verified Foundation Diploma in Data Analysis Using Python – blockchain‑secured, globally recognised.
Professional Diploma in Data Analysis Using Python
Take your Python data analysis skills to the next level. Master data cleaning, merging, grouping, data visualization with Matplotlib and Seaborn, exploratory data analysis, and deliver a complete EDA project.
Pandas: Cleaning, Merging, Group By
- Data Cleaning with Pandas
- Handling Missing Values
- Merging and Joining Datasets
- GroupBy Operations and Aggregation
- Data Transformation Techniques
- Preparing Data for Analysis
Data Visualization: Matplotlib, Seaborn
- Introduction to Matplotlib
- Creating Line, Bar, and Pie Charts
- Introduction to Seaborn
- Statistical Data Visualization
- Customizing Charts and Graphs
- Visualizing Business Data
Exploratory Data Analysis Workflow
- Exploratory Data Analysis Fundamentals
- Descriptive Statistics
- Identifying Patterns and Trends
- Detecting Outliers and Anomalies
- Correlation Analysis
- EDA Reporting Techniques
Project: EDA on Real Dataset
- Project Planning and Dataset Selection
- Data Cleaning and Preparation
- Exploratory Data Analysis
- Data Visualization and Interpretation
- Business Insights and Recommendations
- Final EDA Project Presentation
Upon completion, earn a verified Professional Diploma in Data Analysis Using Python – blockchain‑secured, globally recognised.
Advanced Professional Diploma in Data Analysis Using Python
Reach expert-level proficiency in Python data analysis. Master SQL integration, statistical analysis with SciPy, automation scripting, and deliver an end-to-end data analysis capstone project.
SQL with Python, Database Connection
- Introduction to SQL with Python
- Connecting Python to Databases
- Executing SQL Queries
- Reading Database Tables into Pandas
- Data Extraction and Reporting
- Database Analysis Project
Stats with Python: SciPy, Hypothesis Testing
- Introduction to SciPy
- Descriptive and Inferential Statistics
- Probability Distributions
- Hypothesis Testing
- Correlation and Regression Analysis
- Statistical Analysis with Python
Automating Reports, Scripting
- Python Scripting Fundamentals
- File Handling and Automation
- Automating Data Analysis Workflows
- Generating Automated Reports
- Scheduling Python Scripts
- Practical Automation Project
Data Analysis Project End-to-End
- Business Problem Definition
- Data Collection and Preparation
- Data Analysis and Visualization
- Statistical Interpretation
- Report Writing and Presentation
- Final End-to-End Data Analysis Capstone Project
Upon completion, earn a verified Advanced Professional Diploma in Data Analysis Using Python – blockchain‑secured, globally recognised.
Foundation Diploma in Data Analysis in R
Build a strong foundation in R programming for data analysis. Master R setup, vectors, data frames, data import, dplyr basics, data wrangling, and ggplot2 visualization.
R + RStudio Setup, Basics, Vectors, Data Types
- Installing R and RStudio
- R Programming Syntax and Environment
- Variables, Data Types, and Operators
- Vectors and Vector Operations
- Basic R Functions
- Writing Your First R Programs
Data Frames, Import Data, dplyr Intro
- Introduction to Data Frames
- Importing Data from CSV and Excel Files
- Exploring Datasets
- Introduction to the dplyr Package
- Selecting and Filtering Data
- Basic Data Manipulation with dplyr
Data Wrangling: filter, select, mutate, summarize
- Filtering Data with
filter() - Selecting Variables with
select() - Creating Variables with
mutate() - Summarizing Data with
summarize() - Grouping Data with
group_by() - Data Wrangling Practice Project
Visualization: ggplot2 Basics
- Introduction to ggplot2
- Creating Bar and Column Charts
- Line and Scatter Plots
- Histograms and Box Plots
- Customizing Charts and Themes
- Basic Data Visualization Project
Upon completion, earn a verified Foundation Diploma in Data Analysis in R – blockchain‑secured, globally recognised.
Professional Diploma in Data Analysis in R
Take your R data analysis skills to the next level. Master advanced dplyr and tidyr, advanced ggplot2, statistical tests, correlation, hypothesis testing, regression analysis, and deliver a complete EDA project.
Advanced dplyr, tidyr: Pivot, Separate
- Advanced Data Manipulation with dplyr
- Reshaping Data with tidyr
- Pivoting Data with
pivot_longer()andpivot_wider() - Separating and Uniting Columns
- Joining Multiple Datasets
- Advanced Data Preparation Techniques
Data Visualization: Advanced ggplot2
- Advanced ggplot2 Concepts
- Faceting and Multiple Plots
- Custom Themes and Styling
- Visualizing Time Series Data
- Interactive Data Visualization
- Professional Dashboard Visualizations
Statistical Tests in R
- Descriptive Statistics
- Probability Distributions
- Correlation Analysis
- Hypothesis Testing
- Regression Analysis
- Statistical Reporting in R
Project: R EDA Report
- Data Collection and Preparation
- Data Cleaning and Transformation
- Exploratory Data Analysis
- Statistical Interpretation
- Data Visualization and Reporting
- Final R EDA Project
Upon completion, earn a verified Professional Diploma in Data Analysis in R – blockchain‑secured, globally recognised.
Advanced Professional Diploma in Data Analysis in R
Reach expert-level proficiency in R programming. Master R Markdown for reproducible reports, data.table for big data, Shiny for interactive dashboards, and deliver an end-to-end research analysis capstone project.
R Markdown, Reproducible Reports
- Introduction to R Markdown
- Creating Reproducible Reports
- Embedding Tables and Charts
- Exporting Reports to PDF and HTML
- Automating Report Generation
- Professional Reporting Project
Working with Big Data, data.table
- Introduction to Big Data in R
- Working with the
data.tablePackage - Efficient Data Import and Processing
- Optimizing Data Analysis Performance
- Managing Large Datasets
- Big Data Analysis Project
Shiny Apps Intro
- Introduction to Shiny
- Building User Interfaces
- Reactive Programming in Shiny
- Interactive Charts and Tables
- Deploying Shiny Applications
- Developing a Simple Data Dashboard
Research Analysis Project
- Research Problem Formulation
- Data Collection and Preparation
- Statistical Analysis and Modeling
- Data Visualization and Interpretation
- Research Report Writing
- Final Research Analysis Capstone Project
Upon completion, earn a verified Advanced Professional Diploma in Data Analysis in R – blockchain‑secured, globally recognised.
Roles You Can Pursue with Data Analysis Skills
Develop practical, job-ready data analysis skills that are highly sought after across business, finance, healthcare, education, government, and nonprofit sectors.
What Data Analysis Graduates Say
"The Foundation Diploma in Excel transformed my understanding of data. I now create dashboards for my department with confidence."
— Amara O., Nigeria
"The Professional Diploma in Python took my reporting skills to the next level. The Pandas and visualization modules were game-changers."
— James M., Kenya
"The Advanced Professional Diploma in R prepared me for senior analyst roles. R Markdown and Shiny have revolutionised how I present insights."
— Dr. Sarah K., 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
Choose your track – Excel, Python, or R Programming. Build real-world dashboards and reports, 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