Advanced Excel

Master Advanced Excel techniques including complex formulas, Power Query, Power Pivot, advanced data modeling, automation with VBA, and professional dashboard creation.

Created by

Asogbon Samuel

    • (0 Reviews)

0 Hours

0 Enrolled

English

Last updated

Wed, 08-Apr-2026

Course description

This Advanced Excel course is designed for users who want to reach expert level in Microsoft Excel. 

You will learn how to handle large and complex datasets efficiently using Power Query for data cleaning and transformation, Power Pivot for building robust data models, and DAX formulas for advanced calculations. The course also covers array formulas, advanced lookup techniques, financial functions, scenario analysis, What-If analysis, and professional dashboard development.

A major focus is placed on automation using Macros and Visual Basic for Applications (VBA) teaching you how to automate repetitive tasks, create custom functions, and build interactive tools. By the end of this course, you will be able to work like a professional data analyst or financial modeler, delivering high-quality, automated Excel solutions used in real business environments.

What will i learn?

  • Use Power Query to clean, transform, and automate data import processes Build advanced data models using Power Pivot and DAX formulas Master complex formulas including dynamic arrays, XLOOKUP, and nested functions Create professional, interactive dashboards and reports Automate tasks and build custom solutions using VBA and Macros Perform financial modeling, scenario analysis, and sensitivity analysis Work efficiently with very large datasets without performance issues

Requirements

  • Strong intermediate Excel skills (comfortable with PivotTables, VLOOKUP, basic formulas)
  • Microsoft Excel 2016, 2019, 2021 or Microsoft 365 (Desktop version)
  • A computer with stable internet for downloading practice files

Frequently asked question

Intermediate Excel focuses on PivotTables, charts, and common formulas. Advanced Excel dives deep into Power Query, Power Pivot, DAX, automation with VBA, and building professional-grade solutions.

No prior programming experience is required. The course teaches VBA from the basics with practical business examples.

Yes. Most examples and projects are based on real-world business, finance, and analytics scenarios.

Asogbon Samuel

View profile

₦50000

₦65000

Lectures

0

Skill level

Intermediate

Expiry period

3 Months

Certificate

Yes
Remove from cart Add to cart Buy now

Share this course

Related courses

Intermediate

Excel Intermediary

0

(0 Reviews)

0 Hours

₦20000

₦25000

Enroll now

Intermediate

Power BI

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Intermediate

Tableau

0

(0 Reviews)

0 Hours

₦50000

₦65000

Enroll now

Intermediate

SQL (Structured Query Language)

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Intermediate

Project Management

0

(0 Reviews)

0 Hours

₦50000

₦60000

Enroll now

Advanced

Virtual Assistance for Data Analytics

0

(0 Reviews)

0 Hours

₦100000

₦120000

Enroll now