Microsoft Excel: Master M Language - Power Query in 60 Minutes! | Bash (BizTech Matters) | Skillshare

# Microsoft Excel: Master M Language - Power Query in 60 Minutes!

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
15 Lessons (58m)

0:31

2:41

2:18

2:28

9:58

7:35

2:54

7:59

6:05

2:12

0:35

8:11

2:40

1:07
• ### 15. Thank You!

1:07
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

216

Students

1

Project

Last time you opened a PowerÂ Query file with M Code and are overwhelmed by the number of things to do. You don't know how to make the best use of your time.

But it doesn't have to be this way!

You Will Walk Away With...

• MORE TIME!
• Create your ownÂ M Formulas to perform data transformationsÂ from scratchÂ in just 60 minutes!
• Understand the structureÂ of the M code, and see them in action!
• See how M in PowerÂ Query is usedÂ with real examples!

After this class you will be able to:

• Actually SMILE when you open the PowerÂ Query Editor :-)
• Brag to your friends about how you can useÂ Microsoft PowerÂ Query confidently!

If you're like me, you use Microsoft PowerÂ Query on a daily basis for important tasks, text processing, or reports. Whether it's for business or personal related projects, everyone wants to be able to use PowerÂ Query freely and easily.

We take it up a notchÂ to clean your dirty data and showcase theÂ things you can do in Excel Power Query!

Here is what will we cover:Â

• M Introduction
• Enabling M in Power Query
• Finding the complete list of M functions
• Using M Functions with Real Examples
• Simple Expressions
• Nested Expressions
• Variables
• Functions
• Reusable Functions
• Invoking Functions
• Passing Functions

#### Bash (BizTech Matters)

Online Teaching Excel Expert

Teacher

Hi! I'm Bash and over here at BizTech Matters, I love sharing what I know through online classes, with my over 10 years of IT and teaching experience. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I ensure that I will give you the tools to succeed.

My goal is to show you the essence behind on whatever I'm teaching you. Hop in for a fun ride into learning in the technology world!

Join me in learning the following this growing list of skills:

- Mastering Top Microsoft Excel Formulas

- Mastering SQL Queries

- Create your own Power BI Dashboard!

- Use Excel Power Query to Clean your Dirty Data

- Use the Top 50 Excel Keyboard Short... See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

# Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshareâ€™s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects