Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation
Learn how to use Power Query and code in the M formula language in Excel.
Created by John Bura
01
Skill level
All levels
02
Sections
13
03
Lectures
60
04
Instructor
John Bura
What's inside
This course includes.
✓
13
Sections
✓
60
Lectures
✓
60
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 01 Course Overview 3 lectures
01 What Are Power Query And M
Locked
02 Course Overview
Locked
Source Files 01
Locked
+ 02 Build your first M queries 3 lectures
01 Capitalize A Table Column
Locked
02 Build An Expression With Let
Locked
Source Files
Locked
+ 03 Join tables with M 4 lectures
01 Build And Reference Tables
Locked
02 Append And Combine Tables
Locked
03 Inner Join Tables
Locked
Join tables with M - Source Files
Locked
+ 04 Build M functions to perform tasks 11 lectures
01 Build M Functions To Perform Tasks
Locked
02 Call Functions
Locked
03 Use The Each Keyword
Locked
04 Change A Table With A Function
Locked
05 Loop An Action With A Recursive Function
Locked
06 Calculate Price After Discount 1
Locked
07 Use Optional Parameters To Combine Text
Locked
08 Transform A List With A Function
Locked
06 Calculate Price After Discount
Locked
09 Calculate Number Of Working Days
Locked
Build M functions to perform tasks - Source Files
Locked
+ 05 Work with lists in M 5 lectures
01 Build A List With Each
Locked
02 Concatenate Items In A List
Locked
03 Iterate Over A List
Locked
04 Iterate Over A List With Recursion
Locked
Work with lists in M - Source Files
Locked
+ 06 Build M variables to store data 5 lectures
01 Calculate Affiliate Revenue
Locked
02 Variable Types
Locked
03 Variable Scope - Where Can You Use Variables
Locked
04 Order Of Evaluation
Locked
Build M variables to store data - Source Files
Locked
+ 07 Aggregate table data with M 7 lectures
01 Count Rows
Locked
02 Calculate Profits Per Quarter
Locked
03 Group Similar Rows
Locked
04 Sort A Table
Locked
05 Query Data From Another Spreadsheet
Locked
06 Find Where Sales Met Quota
Locked
Aggregate table data with M - Source Files
Locked
+ 08 Work with tables in M 4 lectures
01 Build Tables
Locked
02 Work With Tables
Locked
03 Fill In A Table
Locked
Work with tables in M - Source Files
Locked
+ 09 Build conditions with M if expressions 2 lectures
01 Build Conditions With If Expressions
Locked
Build conditions with M if expressions - Source Files
Locked
+ 10 Work with M data types 4 lectures
01 Manipulate Text
Locked
02 Work With Numbers
Locked
03 Work With Date, Time And Duration
Locked
Work with M data types - Source Files
Locked
+ 11 Build queries for tables with M 3 lectures
01 Filter A Table By Row
Locked
02 Format A List Of Values Into A Table
Locked
Build queries for tables with M - Source Files
Locked
+ 12 Build calculations for tables with M 5 lectures
01 Build Address Labels
Locked
02 Calculate Percentage Of Total
Locked
03 Calculate Sales Rank
Locked
04 Count Number Of Distinct Rows
Locked
Build calculations for tables with M - Source Files
Locked
+ 13 Fetch data from the web with M 4 lectures
01 Query Tables From The Web
Locked
02 Search For Links On The Web
Locked
03 Check If A Webpage Exists
Locked
Fetch data from various sources with M - Source Files
Locked
Description
About this course.
Power Query
- Free tool part of Excel and Power BI
What is it for?
- Automate manual and repetitive tasks
- Solve data analysis problems that require complex formulas
- Easy to import and transform data in ways Excel finds hard
- Designed to pull data from a source
- Modify it
- Return the modified version
What you can do with Power Query?
- Import data from different sources
- Transform and clean data
- Load data as a basis for reports
Import data from different sources
- Another workbook
- Text file
- Folder
- Sharepoint drive
- Databases
- ...
Example
- Can make a PivotTable from 50 million records
Power Query Editor
- Graphical script editor
- Part of Excel and Power BI
Course Curriculum
- 01 Overview
- 02 Build your first M queries
- 03 Join tables with M
- 04 Build M functions to perform tasks
- 05 Work with lists in M
- 06 Build M variables to store data
- 07 Aggregate table data with M
- 08 Work with tables in M
- 09 Build conditions with M if expressions
- 10 Work with M data types
- 11 Build queries for tables with M
- 12 Build calculations for tables with M
- 13 Fetch data from the web with M
Experience
- Excel experience recommended
- No Power Query or programming experience required
- Programming experience will help
What You’ll Need
- A PC computer
- Power Query isn’t available on Excel for Mac
What You’ll Need
- A free trial or paid license of Excel
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Learn how to use Power Query and code in the M formula language in Excel.