ETI · 06.02

Advanced Excel - Functions, Power Query & Power Pivot

This advanced program helps participants master Excel's powerful analytical capabilities using advanced functions, Power Query, Power Pivot, and data modeling techniques for business reporting and analysis.

Enquire about this course ↗View all courses

Corporate Learning / 2026

Duration2 Days

LanguagesEnglish / Arabic

DeliveryIn-Person / Live Online Instructor-Led

CustomisationAvailable in-house

Course Overview

Practical learning.
Measurable impact.

Every ETI corporate programme can be aligned with your organisation's industry, competency framework, business priorities and learner profile. Practical exercises and workplace scenarios help participants transfer learning into performance.

Learning Objectives

What participants
will be able to do.

01
Apply advanced Excel formulas and functions.
02
Transform and clean data using Power Query.
03
Build data models with Power Pivot.
04
Create efficient reports and dashboards.

Who Should Attend

Designed for professionals
ready to progress.

01Business Analysts
02Finance Professionals
03HR Professionals
04Data Analysts
05Advanced Excel Users

Course Outline

A structured journey
from insight to action.

Facilitated discussion, practical application and workplace-focused learning are woven through every module.

Module↗