Compare with 1 courses
Advanced Excel

Advanced Excel

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

₦50000

₦65000
Learn more
Has discount
Expiry period 3 Months
Made in English
Last updated at Wed May 2026
Level
Intermediate
Total lectures 0
Total quizzes 0
Total duration 0 Hours
Total enrolment 0
Number of reviews 0
Avg rating
Short description Master Advanced Excel techniques including complex formulas, Power Query, Power Pivot, advanced data modeling, automation with VBA, and professional dashboard creation.
Outcomes
  • 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