Power Query Training Course – Clean, merge, and automate your data without coding
- Price
- Duration
- Number of Hours
Each session will take place even if only one person is registered (except in cases of force majeure).
Description of Power Query Training Course
This Power Query training course guides you step by step through the use of Power Query, helping you to become more efficient, reliable and independent, both in Excel and Power BI.
Do you regularly work with Excel files, disorganised tables or heterogeneous data ? Power Query is the ideal tool for cleaning, transforming and automating your data processing, all without writing a single line of code.
Also discover our POWER BI DESKTOP Training Course.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Each session will take place even if only one person is registered (except in cases of force majeure). A preliminary interview is held between the participant and/or a company representative in order to fully assess the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment : during the training course, the trainer assesses the participants’ progress through multiple-choice questions, role-playing exercises and practical work. Participants receive a certificate of completion at the end of the training course.
This training course is part of our Power Platform Training Courses. Explore our full Power Platform programme to automate, analyse and build no-code business applications.
objectives of Power Query Training Course
By the end, each participant will be able to :
- Discover the Power Query interface in Excel and Power BI.
- Connect and import various data sources.
- Clean and transform data: filters, columns, formats, duplicates, etc.
- Merge and cross-reference tables (joins).
- Automate repetitive processes.
- Create reusable and documented queries.
Prerequisites
- Good command of Excel or Power BI (intermediate level).
- No programming knowledge required.
- Ability to handle data tables (files, exports, CRM, etc.).
- Because each participant is unique, a personalised interview with our expert allows us to design a training course that is perfectly aligned with their objectives, level and professional challenges.
Target Audience
Designed for finance, HR, marketing, management, support, and analyst profiles, this introduction will save you valuable time.
Detailed of Power Query Training Course
Understanding Power Query and its positioning
Where to find Power Query (Excel, Power BI), typical use cases, ETL (Extract – Transform – Load) principles
Connecting to data sources
Import from Excel, CSV, web, databases, network shares. Refreshes.
Data cleansing
Delete columns, replace values, detect errors, standardise formats, manage duplicates.
Processing and enrichment
Column splitting, adding conditional columns, grouping, dynamic formatting.
Data merging and cross-referencing
Merging queries (joins), adding columns from other tables, multi-source grouping.
Automation and best practices
Automatic refresh, step history, documentation, secure queries.
The advantages of this training course
This training course :
- Is aimed at Excel/Power BI users who are not developers.
- Focuses on practical business applications rather than pure technical skills.
- Covers real-life scenarios involving file processing and exports.
- Provides a sustainable and automatable method for all departments.
FAQ – Power Query Training
What is Power Query?
Power Query is Microsoft’s data preparation engine, built into Excel, Power BI Desktop and Fabric. It allows you to import, clean, transform and combine data from files, SQL databases, the web, SharePoint or APIs, via a visual interface and the M language. MFE-IT trains analysts to industrialize their data processing with Power Query.
What is the difference between Power Query and VBA macros in Excel?
Power Query provides a visual, step-by-step and reproducible approach to transforming data (ETL), whereas VBA macros rely on code and are more fragile to maintain. Power Query is also more performant on large volumes and compatible with Power BI. The MFE-IT training shows how to replace macros with maintainable Power Query queries.
What can you do with Power Query on a daily basis?
You can consolidate multiple Excel files, clean CSV exports, cross-reference sources (SQL, SharePoint, APIs), pivot and unpivot columns, add calculated columns, and schedule refreshes. MFE-IT covers concrete business use cases: financial reporting, HR, sales and operational monitoring.
How long is the Power Query introduction training at MFE-IT?
The training lasts 2 days (14 hours), remote or on-site, with a maximum of 3 participants per session and 30 days of post-training support included.
Would you like to know about upcoming sessions ?
Would you like to schedule this training course on a specific date ? Contact us by email or by filling out the contact form.