The tool that cleans your messy spreadsheets is already sitting inside Excel. It's called Power Query, and it's the data-cleaning engine built into the Microsoft tools you probably open every day.

In this episode of Simply Explained you will learn:

  • What Power Query Actually Is
  • Where You'll Run Into It
  • The Problem It Solves
  • The Four Phases
  • Applied Steps
  • The M Language
  • Merging and Appending
  • Data Types and Locale
  • Refresh
  • Where Beginners Go Wrong
  • Recap and One Question


Simply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.

This episode includes AI-generated content.

Rss Apple Podcaster
Podden och tillhörande omslagsbild på den här sidan tillhör Mirko Peters | Microsoft 365, Copilot, Azure Cloud & Power Platform. Innehållet i podden är skapat av Mirko Peters | Microsoft 365, Copilot, Azure Cloud & Power Platform och inte av, eller tillsammans med, Poddtoppen.