Excel Advanced for Automation & BI

Overview

Course Description

Advanced Excel course for analysts ready to move beyond data cleaning into automation and business intelligence. Covers advanced formulas, pivot table mastery, macro/VBA fundamentals, and AI-assisted automation with Copilot — equipping professionals to build reusable, automated reporting tools.

Prerequisites: Excel for Data Preparation & Cleaning (Level 2) or equivalent

Career Relevance

Jobs: Business Analyst, Reporting Analyst, Operations Analyst (₦2.5–4M annually)
Bridges the gap between basic Excel skills and BI tools like Power BI
Next step: Power BI for Business Intelligence, Advanced SQL & Data Modeling

Master advanced formulas (dynamic arrays, XLOOKUP, nested INDEX-MATCH)
Build and automate pivot tables and pivot-based dashboards
Use Power Pivot and basic DAX for BI-style analysis
Automate repetitive tasks with macros and VBA basics
Use Excel Copilot for AI-assisted formulas and automation
Design interactive dashboards for business reporting

Module 1: Advanced Formulas & Pivot Tables for BI
Dynamic array formulas

Advanced lookups (XLOOKUP, INDEX-MATCH, nested IFs)

Pivot tables and pivot charts for reporting

Power Pivot and intro to DAX

Practice Project
Module 2: Automation, Macros & Copilot
Introduction to macros and VBA basics

Automating repetitive reporting tasks

Using Excel Copilot for formulas, analysis, and automation

Building interactive, automated dashboards

Capstone Project

Level:        Intermediate-Advanced 
Duration:     2 weeks
Physical Fee: ₦25,000
Virtual Fee:  ₦20,000

Next Cohort
Physical: 8th August, 2026
Virtual: 15th August, 2026

Enroll Now

Excel Advanced for Automation & BI

Course Description

Career Relevance

Certification Requirements

Vision Statement:

Mission Statement: