Excel Power Query and M

Use Power Query to format data

4.35 (39 reviews)
Udemy
platform
English
language
Data Science
category
Excel Power Query and M
358
students
8.5 hours
content
Aug 2022
last update
$69.99
regular price

What you will learn

Build your first M queries

Join tables with M

Build M functions to perform tasks

Work with lists in M

Description

Buff your skills to keep your job and get a raise in ANY economic climate. This course BUNDLE keeps your skills sharp and your paycheque up!

  • Supercharge Data Transformation

  • Use Power Query to format data

This masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.

Frequently Asked Questions

How do I obtain a certificate?

Each certificate in this bundle is only awarded after you have completed every lecture of the course.

Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.

Is this an eBook or videos?

The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code.

Can't I just learn via Google or YouTube?

This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5-course curriculum to take you from absolute beginner to starting a high-paying career.

How will I practice to ensure I'm learning?

With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.

Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you.

Try a course today.

Content

Beginner Section Overview

01 What Are Power Query And M
02 Course Overview

02 Build your first M queries

01 Capitalize A Table Column
02 Build An Expression With Let

03 Join tables with M

01 Build And Reference Tables
02 Append And Combine Tables
03 Inner Join Tables

04 Build M functions to perform tasks

01 Build M Functions To Perform Tasks
02 Call Functions
03 Use The Each Keyword
04 Change A Table With A Function
05 Loop An Action With A Recursive Function
06 Calculate Price After Discount
07 Use Optional Parameters To Combine Text
08 Transform A List With A Function
09 Calculate Number Of Working Days

05 Work with lists in M

01 Build A List With Each
02 Concatenate Items In A List
03 Iterate Over A List
04 Iterate Over A List With Recursion

06 Build M variables to store data

01 Calculate Affiliate Revenue
02 Variable Types
03 Variable Scope - Where Can You Use Variables
04 Order Of Evaluation

07 Aggregate table data with M

01 Count Rows
02 Calculate Profits Per Quarter
03 Group Similar Rows
04 Sort A Table
05 Query Data From Another Spreadsheet
06 Find Where Sales Met Quota

08 Work with tables in M

01 Build Tables
02 Work With Tables
03 Fill In A Table

09 Build conditions with M if expressions

01 Build Conditions With If Expressions

10 Work with M data types

01 Manipulate Text
02 Work With Numbers
03 Work With Date, Time And Duration

11 Build queries for tables with M

01 Filter A Table By Row
02 Format A List Of Values Into A Table

12 Build calculations for tables with M

01 Build Address Labels
02 Calculate Percentage Of Total
03 Calculate Sales Rank
04 Count Number Of Distinct Rows

13 Fetch data from the web with M

01 Query Tables From The Web
02 Search For Links On The Web
03 Check If A Webpage Exists

00 Advanced Section overview

00 Course Overview - Advanced Excel Power Query And M
01 What Are Power Query And M

01 Build expressions with let

01 Build Nested Let Expressions
02 Build A List With A Sequence
03 Build An Unnamed Record

02 Build expressions with each

01 Work With The Each Keyword
02 Generate A List
03 Find An Entry In A Record
04 Select Items From A List
05 Serialize A Column
06 Find Best Match Of Values

03 Build M functions to perform tasks

01 Build A Function
02 Build A Closure
03 Build A Function In A Record
04 Count Fibonacci Numbers With A Recursive Function
05 Remove HTML Tags
06 Build A For Each Loop

04 Work with tables in M

01 Select A Column From A Table
02 Select A Value At A Row And Column
03 Select Row Where A Condition Is Met
04 Cross Join Tables
05 Join Tables On A Key
06 Change Column Types
07 Fill A Table With Random Values

05 Pivot a table

00 What Is Pivoting
01 Pivot A Table

06 Build expressions with evaluate

01 Build An Expression With Evaluate
02 Build A Nested Evaluate Expression
03 Use Global Library Functions

07 Work with matrices in M

00 How To Multiply Matrices
01 Build Matrices In M
02 Multiply Matrices

Reviews

Tomasz
August 20, 2023
Tons of lecturer's mistakes left not explained. She goes over them and leaves the audience misled and confused quite often. However, there are some useful pieces in the course.
Danny
June 1, 2023
This is definitely what I was looking for, a course that goes beyond the Power Query GUI and focuses on authoring custom M Code. It is not a beginner course, neither is it like other courses I've taken. The pace is extremely fast, and the first course I've had to slow down rather than speed up. It's more like dictation than training, nothing is really explained, merely narrated. I only made it to section 5 before I started to struggle and had to resort to YouTube for better explanations of the functions. This course is a good starting point for advance M, and really shows the art of the possible with so I'm satisfied with it.
Carlos
February 24, 2023
It's not a course for Beginners, but I'm learning a lot of M language. Sometimes it's hard to understand, this is not a generic Power Query Course like others
Andrea
January 11, 2023
No course for beginners. Obviously intended for students who want to write programs (literally). Not for students who need to do data transformation in practice. Poor didactic preparation. Even after the 6th section, it is still not clear to me why I should use M instead of Excel for the tasks presented. The editor has not yet been used or explained. The input is always in an empty query. So no intuitive entry is possible. No prepared datasets are used.
Wil
December 5, 2022
The instructor knew the material very well. Unfortunately, this course is structured like learning to drive a car by disassembling the engine parts first. There are 70+ examples in the course, but if your job problem does not fit one of these examples, you will be forced to learn how to do it somewhere else. Also, I did not have Office 365 with Intellisense auto coding prompts. However, you can manage to do this course using Office 2010's Power Query and typing very carefully her code. I wish the course covered more on how to connect to data sources and similar applications. But it was not done that way. I would give at average rating. It was not terrible and it did not cover all the functions from Power Query. The M code is nothing close to VBA. It's like starting from scratch. I understand the difficulty of coming out with a good way to teach it. I just wish it would be similar to how other coding courses are taught.
Victor
November 20, 2022
The teacher knows a lot, that is for sure, but she doesn't explain in detail what is going on in the functions and how they work. For example, I had to watch a Youtube video to understand List.combine, it's not easy!
Jeffery
September 14, 2022
I'm an experienced VBA developer, so the short and sweet lessons here are just right for me. The audio and visual quality are excellent.

Coupons

DateDiscountStatus
9/3/2022100% OFF
expired

Charts

Price

Excel Power Query and M - Price chart

Rating

Excel Power Query and M - Ratings chart

Enrollment distribution

Excel Power Query and M - Distribution chart
4849060
udemy ID
8/24/2022
course created date
9/3/2022
course indexed date
Bot
course submited by