Become an Excel Data Analysis Expert
Master advanced formulas, Power Query, Power Pivot, VBA macros, interactive dashboards, and AI‑powered analytics. 100% online, globally recognised.
Master Excel for Data Analysis
Comprehensive video lessons recommended from excel covering advanced Excel techniques for real‑world data challenges.
Module 1: Excel & Office 365 Essentials
Navigate Excel 365 interface, cloud collaboration, and core features for data analysis.
Module 2: Advanced Formulas & Functions
Master IF, SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP, INDEX-MATCH, and dynamic array formulas.
Module 3: Advanced Formula Techniques
Nested functions, array formulas, named ranges, and formula auditing for complex calculations.
Module 4: Pivot Tables Fundamentals
Create, customise, and format Pivot Tables; use slicers, timelines, and calculated fields.
Module 5: Interactive Dashboards
Design executive dashboards with Pivot Charts, slicers, and dynamic visualisations.
Module 6: Power Query – Data Transformation
Clean, merge, and shape data from multiple sources using Power Query Editor and M language.
Module 7: Power Pivot & DAX
Build data models, relationships, and DAX measures for advanced business intelligence.
Module 8: Macros & VBA Programming
Automate repetitive tasks, record macros, and write custom VBA code for efficiency.
Module 9: Advanced VBA & UserForms
Create custom functions, automate data entry, and build interactive UserForms.
Module 10: Solver & What‑If Analysis
Optimise business decisions with Goal Seek, Scenario Manager, and Solver add‑in.
Module 11: Advanced Data Visualisation
Create waterfall, funnel, heat maps, and custom charts for impactful storytelling.
Module 12: Data Analysis ToolPak & Add‑ins
Use Analysis ToolPak, Power Map, and 3D Maps for statistical and geospatial analysis.
Module 13: Financial Analysis & Modelling
Build financial models, NPV, IRR, loan amortisation, and cash flow forecasts.
Globally Recognised Advanced Excel Certification
Designed for data analysts, BI professionals, finance experts, and anyone who wants to master Excel at an advanced level.
100% Online
Study anywhere, anytime. Self‑paced learning with lifetime access.
Advanced Certification
Earn a verifiable advanced professional certificate recognised worldwide.
Expert Faculty
Learn from Microsoft‑certified Excel masters and data analysts.
Real‑World Projects
Build a portfolio of advanced dashboards, automated reports, and financial models.
Complete Excel Data Analysis Programme
13 intensive modules covering everything from core formulas to VBA and AI‑powered analytics.
- Module 1: Excel & Office 365 Essentials – Cloud collaboration and core features.
- Module 2: Advanced Formulas & Functions – IF, SUMIFS, XLOOKUP, INDEX‑MATCH, dynamic arrays.
- Module 3: Advanced Formula Techniques – Nested functions, array formulas, named ranges.
- Module 4: Pivot Tables Fundamentals – Slicers, timelines, calculated fields.
- Module 5: Interactive Dashboards – Pivot Charts, slicers, dynamic visualisations.
- Module 6: Power Query – Data transformation, merging, cleaning with M language.
- Module 7: Power Pivot & DAX – Data models, relationships, advanced measures.
- Module 8: Macros & VBA Programming – Automation, recorded macros, custom code.
- Module 9: Advanced VBA & UserForms – Custom functions, data entry automation.
- Module 10: Solver & What‑If Analysis – Goal Seek, Scenario Manager, optimisation.
- Module 11: Advanced Data Visualisation – Waterfall, funnel, heat maps, custom charts.
- Module 12: Data Analysis ToolPak & Add‑ins – Statistical analysis, Power Map, 3D Maps.
- Module 13: Financial Analysis & Modelling – NPV, IRR, loan amortisation, cash flow forecasts.
For Experienced Excel Users
Intermediate Excel knowledge or completion of our Professional Certificate is recommended.
Prerequisites
- Intermediate Excel skills (formulas, Pivot Tables, basic charts).
- Familiarity with data analysis concepts.
- Access to Microsoft Excel 2019 or later (Microsoft 365 recommended).
- Proficiency in English (B2 level or equivalent).
Technical Requirements
- Computer with internet access (Windows, macOS, or Linux).
- Microsoft Excel 2019 or later (Power Query, Power Pivot required).
- Modern web browser (Chrome, Firefox, or Edge).
Affordable Advanced Programme
Flexible payment options available.
Programme Fees
| Full Programme Tuition (NGN) – Nigerian Residents | ₦65,000 |
| Full Programme Tuition (USD) – International Students | $45 USD |
| Installment Plan (2 payments) – NGN | ₦33,000 x 2 |
| Registration Fee | ₦3,000 / $3 USD |
| Digital Advanced Certificate & Transcript | Included |
Scholarships available for early applicants. Pay tuition →
Your Future in Advanced Data Analysis
Graduates can pursue senior roles such as:
- Senior Data Analyst
- Business Intelligence Analyst
- Financial Analyst
- Data Scientist (entry)
- Excel/VBA Developer
- BI Consultant
- Operations Research Analyst
- Senior Reporting Analyst
What Our Advanced Graduates Say
Join thousands of professionals who have transformed their data analysis careers.
Ready to Become an Excel Data Analysis Expert?
Earn an Advanced Professional Certificate and unlock senior data roles. Enrol today.