Mastering M Language and Power Query: Excel Automation for M

Learn to build your first query with M in Power Query, reference an Excel current workbook table, and capitalize a column using text.proper.

Learn to use the let keyword in power query to build expressions and define variables. Create and nest lists and records, and index values in the advanced editor.

Build and reference tables in Power Query using the Excel current workbook, name the tables and queries for reuse, and prepare to join data.

Combine and join tables in Power Query using the advanced editor and blank queries to create a unified table with year, course, new students, and sales.

Perform an inner join of two tables in Power Query Editor using table.join, joining on the year and course to produce a clean result with new students and sales columns.

Learn to build and call M functions in Power Query, defining parameters, types, and optional arguments, and see how to return results in a worksheet.

Learn to use the each keyword in Power Query by creating a blank query, defining my each function in the advanced editor, and invoking it with values.

Master M language and Power Query to transform an Excel table with a prebuilt function and a custom function that adds one to each student.

Learn recursion in Power Query M by building a self‑calling function with a base case, avoiding infinite loops, and summing values like 3 to 6 and 10 to 55.

Create a Power Query function to compute price after discount by converting a discount percentage to a decimal and applying it to the original price.

Create a Power Query function with optional middle name, using Text.Combine to join first, middle, and last names with a space, and handle missing values gracefully.

Transform a list with a function in Power Query to multiply each value by two, demonstrating applying a single function to an entire list within Excel.

Master the M language in Power Query by building a function to calculate working days between two dates, removing weekends and counting weekdays in Excel.

Learn to build a list using the each keyword in power query editor, creating a function that multiplies elements by ten and applying it with list transform.

Combine lists into a single string in Power Query M by converting items to text and joining with spaces to automate Excel reports.

Iterate over a list in Power Query using recursion or list accumulate. Create a blank query, define a function to add items, and apply it to list items.

Use recursion in Power Query M to iterate over a list, with a decreasing index and stop at zero, leveraging list accumulate to add ten to each element.

Practice building functions in M and Power Query to calculate affiliate revenue in Excel, using variables and optional user input for sales and rate.

Explore variable types in M: regular identifiers, quoted identifiers, and generalized identifiers, learn immutability, lexical rules, and how to reference workbook tables in Power Query.

Explore variable scope in M language, demonstrating how nested expressions access parent variables while outer terms remain inaccessible, and use records and properties like sales and tax.

In power query m, the order of evaluation follows dependency ordering, executing only what is needed and skipping unused variables, as shown with list transform and multiply by two.

Learn to count rows in a Power Query table and count by group using M, with techniques using table row count and grouping by quarter in Excel.

Open Power Query Editor to create a new blank query, reference the current workbook table, group by quarter, count rows, and sum profits to produce per-quarter totals.

Learn to group similar rows in Power Query by using global versus local group kinds, counting rows per course in a sample Excel table and comparing consecutive vs global groups.

sort a table in power query editor using the course sales table, choosing ascending or descending order, and apply multiple criteria for deterministic results.

Learn how to query data from another spreadsheet using Power Query, converting CSV data into a formatted table with headers and proper types.

Learn to use M in Power Query to find which courses meet a sales quota by filtering a table where sales exceed a given value, with a reusable function.

Learn to build tables in M using the hashtag table keyword, with and without data types, by creating headers and nested row lists in Power Query.

Learn to query Power Query tables in Excel using m language by selecting rows and columns, referencing tables, and combining tables with the ampersand, including handling nulls.

Learn to fill blank rows in a table with Power Query's fill down, propagating category values downward to complete the dataset.

Master conditions in M with if expressions and IFF, from simple chains to efficient else and else if, and filter a table by course id using equality in Power Query.

Explore text manipulation in M with Power Query: create strings and booleans, compare text with case-insensitive equality, concatenate with spaces, format numbers, and handle nulls.

Master numbers in Power Query and the M language, exploring the advanced editor, whole numbers, decimals, and notation like 0.5 and 5e2, and how 5.0 is preserved.

Explore date, time, and duration in Power Query M by creating date, time, duration, and date time objects in Excel, then concatenate and adjust them with duration and time zone.