Microsoft Excel Power Query - Master Power Query!

Master Power Query's data cleaning and transformation, merging sources into a single model, and use the query editor ribbon to build, edit, and load clean data.

Learn Power Query in Excel to split text fields into code, item, description, and size, using space-based and character-based splits, then concatenate and manage data types for clean results.

Learn to trim extra spaces with Power Query, clean names for accurate counts in a pivot table, and refresh queries to automatically apply the same steps to new data.

Open the query editor, change the date column to date and the payment column to currency for proper formatting. Then load the cleaned data into a new worksheet for analysis.

Master power query to parse urls, clean dirty data, and extract category and value using split by delimiter in the query editor, then load results.

Learn to group sales data by salesperson and region in Power Query, compute total sales for each combination, and note that the date column is excluded from the results.

Master Power Query to import multiple files from a folder, consolidate Africa, Americas, and Europe sales data into a single table, and clean, transform, and load it.

Sort data by salesperson and sales region in Power Query, then filter by sales of at least 30,000 and convert order date to date, finally load the cleaned data.

Learn to extract data using two criteria in Power Query, clean up extra headers, fill down owner values, and filter addresses by private events allowed and lot size 20000–30000.

Extract data from multiple worksheets with Power Query, combine into a single table, clean headers and columns, then load for pivot tables and reports.

Master Power Query with a step-by-step merge of two tables, linking on student id to compute each student’s class count and build a unified people table.

Learn to consolidate multiple sheets using Power Query, append tables, and produce a pivot table; refresh updates automatically when source data changes.

Explore join concepts in Power Query by linking student and enrollment tables to eliminate data duplication, enable single updates, and prepare for various join types and left joins.

Master the right anti join in Power Query to identify students who still need counselling by comparing the needs counselling data with the table of students who underwent counselling.

Master auto cleanup by loading folder data into a central table, splitting names into first and last, and using Power Query to auto-refresh with new files and pivot insights.

Learn to use M functions in Power Query to create custom columns, extract months from dates, and pad ideas with zeros to eight digits.

Learn to view and edit M code in Power Query by trimming names, enabling the formula bar and query settings, and inspecting the complete M script in the advanced editor.

Explore simple and let expressions in power query m code by creating a new query, writing arithmetic like five plus ten, and defining intermediate variables to improve readability.

Explore M variables in Power Query, comparing regular identifiers with coded identifiers that begin with a hash and quotes, enabling spaces and any characters for clearer, readable expressions.

Explore M functions in power query, defining and invoking functions with parameters, and returning computed values, including nesting and optional parameters such as discount calculations.

Create reusable M functions in Power Query by defining a function once and calling it from multiple queries to reuse code, and compute a discounted price with two variables.

Explore how to pass a function to another function in M, using the table add column approach to create a new column from a row-based generator and customize values.

Explore how to pass functions in M by leveraging the each keyword to simplify single-argument transformations, inline function definitions, and readable code in Power Query.