Excel Power Query And M

Use Power Query to format data

What you'll learn
Build your first M queries
Join tables with M
Build M functions to perform tasks
Work with lists in M
Requirements
No experience necessary
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 TransformationUse Power Query to format dataThis 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 QuestionsHow 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.

Overview

Lecture 0 01 What Are Power Query And M

Lecture 0 02 Course Overview

Lecture 0 01 Capitalize A Table Column

Lecture 0 02 Build An Expression With Let

Lecture 0 01 Build And Reference Tables

Lecture 0 02 Append And Combine Tables

Lecture 0 03 Inner Join Tables

Lecture 0 01 Build M Functions To Perform Tasks

Lecture 0 02 Call Functions

Lecture 0 03 Use The Each Keyword

Lecture 0 04 Change A Table With A Function

Lecture 0 05 Loop An Action With A Recursive Function

Lecture 0 06 Calculate Price After Discount

Lecture 0 07 Use Optional Parameters To Combine Text

Lecture 0 08 Transform A List With A Function

Lecture 0 09 Calculate Number Of Working Days

Lecture 0 01 Build A List With Each

Lecture 0 02 Concatenate Items In A List

Lecture 0 03 Iterate Over A List

Lecture 0 04 Iterate Over A List With Recursion

Lecture 0 01 Calculate Affiliate Revenue

Lecture 0 02 Variable Types

Lecture 0 03 Variable Scope - Where Can You Use Variables

Lecture 0 04 Order Of Evaluation

Section 1: 07 Aggregate table data with M

Lecture 0 01 Count Rows

Lecture 1 02 Calculate Profits Per Quarter

Lecture 2 03 Group Similar Rows

Lecture 3 04 Sort A Table

Lecture 4 05 Query Data From Another Spreadsheet

Lecture 5 06 Find Where Sales Met Quota

Section 2: 08 Work with tables in M

Lecture 6 01 Build Tables

Lecture 7 02 Work With Tables

Lecture 8 03 Fill In A Table

Section 3: 09 Build conditions with M if expressions

Lecture 9 01 Build Conditions With If Expressions

Section 4: 10 Work with M data types

Lecture 10 01 Manipulate Text

Lecture 11 02 Work With Numbers

Lecture 12 03 Work With Date, Time And Duration

Section 5: 11 Build queries for tables with M

Lecture 13 01 Filter A Table By Row

Lecture 14 02 Format A List Of Values Into A Table

Section 6: 12 Build calculations for tables with M

Lecture 15 01 Build Address Labels

Lecture 16 02 Calculate Percentage Of Total

Lecture 17 03 Calculate Sales Rank

Lecture 18 04 Count Number Of Distinct Rows

Section 7: 13 Fetch data from the web with M

Lecture 19 01 Query Tables From The Web

Lecture 20 02 Search For Links On The Web

Lecture 21 03 Check If A Webpage Exists

Section 8: 00 Advanced Section overview

Lecture 22 00 Course Overview - Advanced Excel Power Query And M

Lecture 23 01 What Are Power Query And M

Section 9: 01 Build expressions with let

Lecture 24 01 Build Nested Let Expressions

Lecture 25 02 Build A List With A Sequence

Lecture 26 03 Build An Unnamed Record

Section 10: 02 Build expressions with each

Lecture 27 01 Work With The Each Keyword

Lecture 28 02 Generate A List

Lecture 29 03 Find An Entry In A Record

Lecture 30 04 Select Items From A List

Lecture 31 05 Serialize A Column

Lecture 32 06 Find Best Match Of Values

Section 11: 03 Build M functions to perform tasks

Lecture 33 01 Build A Function

Lecture 34 02 Build A Closure

Lecture 35 03 Build A Function In A Record

Lecture 36 04 Count Fibonacci Numbers With A Recursive Function

Lecture 37 05 Remove HTML Tags

Lecture 38 06 Build A For Each Loop

Section 12: 04 Work with tables in M

Lecture 39 01 Select A Column From A Table

Lecture 40 02 Select A Value At A Row And Column

Lecture 41 03 Select Row Where A Condition Is Met

Lecture 42 04 Cross Join Tables

Lecture 43 05 Join Tables On A Key

Lecture 44 06 Change Column Types

Lecture 45 07 Fill A Table With Random Values

Section 13: 05 Pivot a table

Lecture 46 00 What Is Pivoting

Lecture 47 01 Pivot A Table

Section 14: 06 Build expressions with evaluate

Lecture 48 01 Build An Expression With Evaluate

Lecture 49 02 Build A Nested Evaluate Expression

Lecture 50 03 Use Global Library Functions

Section 15: 07 Work with matrices in M

Lecture 51 00 How To Multiply Matrices

Lecture 52 01 Build Matrices In M

Lecture 53 02 Multiply Matrices

Anyone interested in manipulating Excel sheets with Power Query