Excel - Discover Power Query and dynamically connect your data

Get to know better Microsoft Excel and Power BI data models with the M fornula language reference.

Upcoming sessions

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306

Course outline

Duration : 1 day

© AFI Expertise inc.

This training course is aimed at data analysis professionals and BI experts who want to deepen their knowledge of Microsoft Excel and Power BI data models using the M language to connect different data sources, transform data and optimize data models within their organization.


Professionals, data engineers and data analysts wishing to import, transform and load data in the Power Query editor


  • Master the skills needed to clean, filter, sort, aggregate, merge and transform data
  • Create a Date table
  • Master the best practices

Teaching method

Lectures - demonstrations - guided and individual exercises


Chapter 1 - Introduction to Power Query
  • What is Power Query
  • Why use it
  • Understanding the Power Query editor
Chapter 2 - Querying data sources
  • Understanding data access functions
  • Data loading options
  • Discover the impact on data refreshing
Chapter 3 - Transforming master data
  • Transforming basic data
  • Transforming text columns
  • Transform number columns
  • Transforming date columns
  • Using duration functions
  • Learn to use error functions
Chapter 4 - Using advanced queries
  • Pivoting and depivoting columns
  • Simplify and standardize names
  • Adjust column types
  • Combine several tables into one
  • Using the advanced editor M
Chapter 5 - Creating a date table
  • Create a date list
  • Transform list into table
  • Change data type
  • Add columns Year, Month, Day, ...
  • Add a conditional column
  • Update a date
Chapter 6 - Apply good practices
  • Reviewing the best practices in Power Query

Related courses

Power BI - Discover Power Query and dynamically connect your data | AFI Expertise

Surround yourself with the best

Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Marc Maisonneuve
Marc Maisonneuve
Training program director
Marc Maisonneuve has acted as a Training Program Director, professional effectiveness trainer and user tools practice leader at AFI for several years. Mr. Maisonneuve is known for his analytical skills, his legendary calm and his undeniable desire to encourage people to develop their skills. He has the ability to present technological solutions in a natural way and to adapt them to the concrete needs of the workplace.
Vicky Moreau
Vicky Moreau
Vicky Moreau is a passionate freelancer and professional in the area of office automation. She holds a college diploma in office automation, most of her solid experience with the Office Suite was acquired while being an autodidact. In fact, she has successfully completed an MOS (Microsoft Office Specialist) Excel certification.
Francis Ferland-Stevenson
Francis Ferland-Stevenson
Francis began as a trainer more than 5 years ago by testing office automation tools designed specifically to met the needs of his colleagues. His calm and his empathy makes him able to adapt his language according to the level of experience of the group. This makes his learnings clear and accessible to anyone. As a trainer, he is therefore attentive to the needs of his students to make sure they meet their objectives and face the challenges.

Soyez au fait des tendances, innovations, bonnes pratiques et exclusivités

Stay in touch

Pour les individus

Pour les organisations

Thèmes Afi U.

Formations certifiées

À propos

La Famille Edgenda


AFI par Edgenda

Apprentx par Edgenda

Afi U.


Besoin d’aide ? Parlez à un conseiller ou appelez au 1 877 624.2344


Copyright © 2023 Edgenda inc.