Microsoft Power Query Advanced

IT-1365

Course Code

5 Days

Duration

Upcoming Dates

Sector Name

Information Technology

Send by WhatsApp

14 Dec 2026 | 18 Dec 2026

Dubai, UAE

$4,250

Limited Seats

11 Jan 2027 | 15 Jan 2027

Dubai, UAE

$4,250

Upcoming

10 May 2027 | 14 May 2027

Abu Dhabi, UAE

$4,250

Upcoming

09 Aug 2027 | 13 Aug 2027

Barcelona, Spain

$4,950

Upcoming

Course Introduction

Power Query is one of the most effective tools in Excel use for data discovery, transformation, and enrichment. It allows you to combine data quickly and easily from one or more structured or semi-structured sources (Excel, CSV, relational databases, SAP, online services, etc.) as well as to clean, reshape, and combine data with ease, no matter where it comes from.

This training course is designed to help participants gain the necessary skills and knowledge in utilizing Power Query in mastering data and advanced techniques.

Course Objectives

Import data from external sources (ex: Access, SQL, Web, etc.).
Utilize advanced transformation techniques and patterns to solve various data challenges
Apply techniques in optimizing existing queries and future proof new queries
Obtain an in-depth understanding of the M language, and advanced M Language techniques.
Aggregate and extrapolate information from incomplete data.
Edit query scripts using the M programming language.