Trang chủ

Office Productivity

Power Query

Excel Power Query and M

Excel Power Query and M

Loại khoá học: Microsoft

Use Power Query to format data

50.000 VND

429.000 VND

Đầy Đủ Bài Giảng

Học Online Tiện Lợi

Kích Hoạt Nhanh 2-5 Phút

Thanh toán tự động

Được phép tải xuống

Mô tả

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.

Bạn sẽ học được gì

Build your first M queries

Join tables with M

Build M functions to perform tasks

Work with lists in M

Yêu cầu

No experience necessary

Nội dung khoá học

21 sections

Beginner Section Overview

2 lectures

01 What Are Power Query And M

08:16

02 Course Overview

06:16

02 Build your first M queries

2 lectures

01 Capitalize A Table Column

06:39

02 Build An Expression With Let

17:09

03 Join tables with M

3 lectures

01 Build And Reference Tables

08:08

02 Append And Combine Tables

05:33

03 Inner Join Tables

05:33

04 Build M functions to perform tasks

9 lectures

01 Build M Functions To Perform Tasks

08:13

02 Call Functions

05:10

03 Use The Each Keyword

02:33

04 Change A Table With A Function

07:30

05 Loop An Action With A Recursive Function

08:02

06 Calculate Price After Discount

06:09

07 Use Optional Parameters To Combine Text

05:13

08 Transform A List With A Function

02:09

09 Calculate Number Of Working Days

12:20

05 Work with lists in M

4 lectures

01 Build A List With Each

05:16

02 Concatenate Items In A List

05:01

03 Iterate Over A List

04:17

04 Iterate Over A List With Recursion

03:26

06 Build M variables to store data

4 lectures

01 Calculate Affiliate Revenue

04:37

02 Variable Types

05:49

03 Variable Scope - Where Can You Use Variables

08:57

04 Order Of Evaluation

05:18

07 Aggregate table data with M

6 lectures

01 Count Rows

07:32

02 Calculate Profits Per Quarter

05:55

03 Group Similar Rows

05:59

04 Sort A Table

05:27

05 Query Data From Another Spreadsheet

07:18

06 Find Where Sales Met Quota

02:55

08 Work with tables in M

3 lectures

01 Build Tables

06:55

02 Work With Tables

05:37

03 Fill In A Table

03:27

09 Build conditions with M if expressions

1 lectures

01 Build Conditions With If Expressions

08:14

10 Work with M data types

3 lectures

01 Manipulate Text

11:34

02 Work With Numbers

03:00

03 Work With Date, Time And Duration

07:52

11 Build queries for tables with M

2 lectures

01 Filter A Table By Row

06:59

02 Format A List Of Values Into A Table

07:57

12 Build calculations for tables with M

4 lectures

01 Build Address Labels

08:26

02 Calculate Percentage Of Total

06:44

03 Calculate Sales Rank

07:04

04 Count Number Of Distinct Rows

06:59

13 Fetch data from the web with M

3 lectures

01 Query Tables From The Web

07:15

02 Search For Links On The Web

08:09

03 Check If A Webpage Exists

06:24

00 Advanced Section overview

2 lectures

00 Course Overview - Advanced Excel Power Query And M

04:09

01 What Are Power Query And M

08:15

01 Build expressions with let

3 lectures

01 Build Nested Let Expressions

03:53

02 Build A List With A Sequence

02:43

03 Build An Unnamed Record

04:14

02 Build expressions with each

6 lectures

01 Work With The Each Keyword

05:00

02 Generate A List

05:40

03 Find An Entry In A Record

02:16

04 Select Items From A List

05:06

05 Serialize A Column

13:43

06 Find Best Match Of Values

21:49

03 Build M functions to perform tasks

6 lectures

01 Build A Function

03:21

02 Build A Closure

06:27

03 Build A Function In A Record

04:23

04 Count Fibonacci Numbers With A Recursive Function

07:04

05 Remove HTML Tags

09:19

06 Build A For Each Loop

09:38

04 Work with tables in M

7 lectures

01 Select A Column From A Table

03:40

02 Select A Value At A Row And Column

03:05

03 Select Row Where A Condition Is Met

03:53

04 Cross Join Tables

08:40

05 Join Tables On A Key

05:48

06 Change Column Types

03:49

07 Fill A Table With Random Values

07:12

05 Pivot a table

2 lectures

00 What Is Pivoting

01:28

01 Pivot A Table

12:05

06 Build expressions with evaluate

3 lectures

01 Build An Expression With Evaluate

03:06

02 Build A Nested Evaluate Expression

03:04

03 Use Global Library Functions

02:27

07 Work with matrices in M

3 lectures

00 How To Multiply Matrices

03:03

01 Build Matrices In M

04:32

02 Multiply Matrices

17:45

Đánh giá của học viên

Chưa có đánh giá

Course Rating

5

0%

4

0%

3

0%

2

0%

1

0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Email

Nội dung

Khoá học liên quan

How To Create 2D Defender Game With Unity & C#

How To Create 2D Defender Game With Unity & C#

The Complete UML Course (2024): Learn to Design UML Diagrams

The Complete UML Course (2024): Learn to Design UML Diagrams

Master Network Automation with Python for Network Engineers

Master Network Automation with Python for Network Engineers

Unity Mobile Game Development - Exterminator

Unity Mobile Game Development - Exterminator

Mastering CSS Grid 2023 - With 3 cool projects

Mastering CSS Grid 2023 - With 3 cool projects

Django 3 - Full Stack Websites with Python Web Development

Django 3 - Full Stack Websites with Python Web Development

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi