About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Excel: Power Query - Master Your Data in 3 Hours
Master Power Query in 120 Minutes
Excel Power Query- Introduction
Preview
Download Exercise Files
Excel Power Query- Query Editor Ribbon
Transform Data: Trim in Excel Power Query
Transform Data: Format Dates and Values in Excel Power Query
Transform Data: Parsing URLs in Excel Power Query
Transform Data: Split Text Fields in Excel Power Query
Transform Data: Group By in Excel Power Query
Transform Data: Unpivoting Columns in Excel Power Query
Transform Data: Pivoting Column in Excel Power Query
Transform Data: Split Columns into Other Columns in Excel Power Query
Transform Data: Filtering Rows in Excel Power Query
Transform Data: Sorting Column in Excel Power Query
Transform Data: Transform and Add Columns in Excel Power Query
From Folder: Import From Folder in Excel Power Query
From Folder: Doing Auto Cleanup in Excel Power Query
From Folder: Extract Data from Forms in Excel Power Query
From Workbook: Extract Multiple Criteria in Excel Power Query
From Workbook: Extract Multiple Worksheet in Excel Power Query
Joins: Intro to Joins
Joins: Merging
Joins: Full Outer Join
Joins: Right Anti Join
Power Query: Convert Reports into Pivot Tables
Power Query Modulo
Welcome to the M Language Course
Download Exercise Files
Excel M Language: Introduction
Preview
Enabling M in Excel Power Query
Finding the list of M functions
Using M Functions
Simple Expressions
Simple Expressions: Nested Expressions
Variables
Functions
Functions: Reusable Functions
Functions: Invoking
Functions: Passing Functions
Functions: The Keyword Each
Joins: Merging
Excel: Power Query - Master Your Data in 3 Hours
Master Power Query in 120 Minutes
By:
Bryan Hong
7 minutes
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
You need to have access to the item to view this lesson.
One-time Fee
$10
List Price:
$199
You save:
$189
Buy Class
€9.61
List Price:
€191.31
You save:
€181.70
Buy Class
£7.97
List Price:
£158.77
You save:
£150.80
Buy Class
CA$14.38
List Price:
CA$286.22
You save:
CA$271.84
Buy Class
A$16.04
List Price:
A$319.31
You save:
A$303.27
Buy Class
S$13.58
List Price:
S$270.29
You save:
S$256.71
Buy Class
HK$77.67
List Price:
HK$1,545.76
You save:
HK$1,468.08
Buy Class
CHF 8.99
List Price:
CHF 178.99
You save:
CHF 170
Buy Class
NOK kr113.74
List Price:
NOK kr2,263.46
You save:
NOK kr2,149.72
Buy Class
DKK kr71.71
List Price:
DKK kr1,427.20
You save:
DKK kr1,355.48
Buy Class
NZ$17.73
List Price:
NZ$352.84
You save:
NZ$335.11
Buy Class
د.إ36.73
List Price:
د.إ730.92
You save:
د.إ694.19
Buy Class
৳1,193.10
List Price:
৳23,742.76
You save:
৳22,549.66
Buy Class
₹852.47
List Price:
₹16,964.29
You save:
₹16,111.81
Buy Class
RM44.69
List Price:
RM889.33
You save:
RM844.64
Buy Class
₦15,456
List Price:
₦307,574.40
You save:
₦292,118.40
Buy Class
₨2,779.55
List Price:
₨55,313.12
You save:
₨52,533.56
Buy Class
฿341.80
List Price:
฿6,801.82
You save:
฿6,460.02
Buy Class
₺352.61
List Price:
₺7,017.09
You save:
₺6,664.48
Buy Class
B$67.46
List Price:
B$1,342.57
You save:
B$1,275.10
Buy Class
R186.28
List Price:
R3,707.15
You save:
R3,520.86
Buy Class
Лв18.81
List Price:
Лв374.31
You save:
Лв355.50
Buy Class
₩14,650.22
List Price:
₩291,539.40
You save:
₩276,889.17
Buy Class
₪36.64
List Price:
₪729.20
You save:
₪692.56
Buy Class
₱579.65
List Price:
₱11,535.13
You save:
₱10,955.47
Buy Class
¥1,574.40
List Price:
¥31,330.65
You save:
¥29,756.25
Buy Class
MX$201.71
List Price:
MX$4,014.20
You save:
MX$3,812.48
Buy Class
QR36.31
List Price:
QR722.60
You save:
QR686.29
Buy Class
P138.66
List Price:
P2,759.41
You save:
P2,620.74
Buy Class
KSh1,290.40
List Price:
KSh25,678.96
You save:
KSh24,388.56
Buy Class
E£508.99
List Price:
E£10,128.92
You save:
E£9,619.92
Buy Class
ብር1,271.21
List Price:
ብር25,297.26
You save:
ብር24,026.04
Buy Class
Kz9,120
List Price:
Kz181,488
You save:
Kz172,368
Buy Class
CLP$9,900.99
List Price:
CLP$197,029.70
You save:
CLP$187,128.71
Buy Class
CN¥72.98
List Price:
CN¥1,452.48
You save:
CN¥1,379.49
Buy Class
RD$608.17
List Price:
RD$12,102.65
You save:
RD$11,494.48
Buy Class
DA1,352.26
List Price:
DA26,909.97
You save:
DA25,557.71
Buy Class
FJ$23.18
List Price:
FJ$461.41
You save:
FJ$438.22
Buy Class
Q76.90
List Price:
Q1,530.41
You save:
Q1,453.51
Buy Class
GY$2,088.84
List Price:
GY$41,567.99
You save:
GY$39,479.15
Buy Class
ISK kr1,394.80
List Price:
ISK kr27,756.52
You save:
ISK kr26,361.72
Buy Class
DH100.68
List Price:
DH2,003.60
You save:
DH1,902.92
Buy Class
L183.79
List Price:
L3,657.43
You save:
L3,473.64
Buy Class
ден591.76
List Price:
ден11,776.08
You save:
ден11,184.31
Buy Class
MOP$79.87
List Price:
MOP$1,589.43
You save:
MOP$1,509.56
Buy Class
N$185.64
List Price:
N$3,694.36
You save:
N$3,508.72
Buy Class
C$367.38
List Price:
C$7,310.90
You save:
C$6,943.52
Buy Class
रु1,359.77
List Price:
रु27,059.52
You save:
रु25,699.74
Buy Class
S/37.17
List Price:
S/739.84
You save:
S/702.66
Buy Class
K40.52
List Price:
K806.39
You save:
K765.87
Buy Class
SAR37.54
List Price:
SAR747.12
You save:
SAR709.58
Buy Class
ZK276.30
List Price:
ZK5,498.56
You save:
ZK5,222.25
Buy Class
L47.83
List Price:
L951.94
You save:
L904.10
Buy Class
Kč241.40
List Price:
Kč4,803.95
You save:
Kč4,562.55
Buy Class
Ft3,939.12
List Price:
Ft78,388.65
You save:
Ft74,449.52
Buy Class
SEK kr110.64
List Price:
SEK kr2,201.89
You save:
SEK kr2,091.24
Buy Class
ARS$10,253.36
List Price:
ARS$204,041.87
You save:
ARS$193,788.51
Buy Class
Bs68.99
List Price:
Bs1,372.92
You save:
Bs1,303.93
Buy Class
COP$44,169.96
List Price:
COP$878,982.39
You save:
COP$834,812.42
Buy Class
₡5,069.39
List Price:
₡100,880.97
You save:
₡95,811.57
Buy Class
L253.67
List Price:
L5,048.06
You save:
L4,794.38
Buy Class
₲77,865.54
List Price:
₲1,549,524.33
You save:
₲1,471,658.78
Buy Class
$U444.41
List Price:
$U8,843.80
You save:
$U8,399.39
Buy Class
zł41
List Price:
zł816.02
You save:
zł775.01
Buy Class
Already have an account?
Log In
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts