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.
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.
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 of Power Query Training Course
- 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.
FORMA-IT's training courses are also supportive
At Forma-IT, we believe that training can also be a lever for solidarity. This is why part of each registration is donated to associations that work in areas that are close to our hearts:
The SPA, for animal protection
The Restos du Cœur, for the fight against precariousness
Ludopital, to make the daily lives of hospitalized children easier
- APF France Handicap, for the rights of people with disabilities and their families
By choosing Forma-IT, you invest in your skills while contributing to essential causes.
Our related training courses
POWER BI DESKTOP Training Course
Design your dashboard. Have a good technical knowledge of the DAX language.
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.