Home Search Profile

Master Power Query M Language: Complete 2024 Guide

Focused View

57:27

  • 1 -Introduction to Power Query M Language basics.mp4
    00:59
  • 1 -02. M Language 101.mp4
    09:57
  • 1 -03. Lists in M Language.mp4
    09:52
  • 1 -04. Records in M Language.mp4
    05:15
  • 1 -05. Tables in M Language.mp4
    13:03
  • 1 -06. each and x lambda function.mp4
    11:19
  • 1 -07. if then else try otherwise in M Language.mp4
    03:46
  • 1 -08. let expressions in M Language.mp4
    03:16
  • More details


    Course Overview

    This comprehensive course teaches you the fundamentals of Power Query M Language, from basic syntax to advanced data manipulation techniques, helping you automate and optimize your Excel workflows.

    What You'll Learn

    • Core concepts of M Language including Lists, Records, and Tables
    • How to use each _ and x lambda functions for data transformation
    • Conditional logic with if-then-else, try, and otherwise expressions

    Who This Is For

    • Excel users looking to automate data processing
    • Analysts who want to understand Power Query's generated code
    • Anyone seeking to master M Language fundamentals

    Key Benefits

    • Save hours by automating repetitive data tasks
    • Gain deep understanding of Power Query's underlying language
    • Write and modify M code with confidence

    Curriculum Highlights

    1. M Language 101: Syntax and Structure
    2. Working with Lists, Records, and Tables
    3. Advanced Functions and let Expressions
    Focused display
    Category
    • language english
    • Training sessions 8
    • duration 57:27
    • Release Date 2025/05/25