Excel Power Query Course: Power Query Tutorial for Beginners

In this Power Query tutorial, we introduce you to Power Query, get you familiar with the Power Query Editor, teach you how to import multiple files and data sources into Power Query, how to combine data, merge queries and so much more.

Power Query in Excel can open up a world of data analyzing possibilities. In this Power Query course, we assume that you are an intermediate to advanced Excel user, but that you haven't used Power Query in Excel before.

📝Tutorial Markers:

0:00:00 - Welcome and Overview
0:03:09 - What is Power Query
0:08:34 - What is Power Pivot
0:12:17 - Exploring the Power Query Editor
0:18:47 - Common Power Query Transformations
0:27:46 - Editing an Existing Query
0:37:42 - Import Multiple Files from a Folder
0:48:48 - Connect to Data in Another Excel Workbook
0:58:26 - Checking the Location of your Query's Source
1:02:00 - Unpivoting Columns
1:07:33 - Combine Data from Multiple Tables with Merge Queries
1:13:44 - Use Merge Queries to Compare Two Tables
1:18:48 - Stack Data into One Table with Append Queries
1:24:51 - Duplicating and Referencing Queries
1:34:01 - Grouping and Aggregating Data
1:41:54 - Conditional Columns in Power Query

💻Watch more free popular training tutorials from Simon Sez IT:

✅Check out our FREE 300+ hour training course playlist here 👉

✅Data Visualization playlist here

✅Excel 2021 Tutorials for Beginners playlist

✅Power BI Tutorials for Beginners. Master Power BI! playlist

✅Alteryx for Beginners playlist

💬Stay in touch!

🔔Subscribe to our channel:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

[bens.]

Put it on 1.5X speed. You are welcome.

[larahporter]

I like when teachers speak slowly and make pauses. It gives my brain a moment to process. Very good 👍

[Deedington]

I love the clear precise style in which Simon Sez explains the content! Couldn't be any better for professionals. Thank you Simon!

[bolaowoade]

Really good and clear tutorial. I've struggles with Power Query previously but this tutorial has helped me learn the basics of it. Thank you.

[viswas]

Thank you Allan and Simon Sez IT team. This course is awesome. The way Allan has presented is so good. I won’t subscribe to any of the training channels but this time I did subscribe to Simon Sez. Hearty thanks.

[haileandarg]

The way Simon Sez teaches the material is very clear and concise, and I really appreciate that!

[adhikarikabi]

mate, !!!!we have so much sugar coated online sites and teachers and what not, flashy yet completely hollow, you are the best genuine teacher I have come across in internet for quite sometimes now. I mean I would be more than happy to contribute this gentleman`s hard work if there are ways to do so. I want to enrol in your classes if there are any and best fit for someone who is from Australia. Cheers!

[felipe]

Amazing! Amazing! Amazing explanation!

The tools and features used in this video are the best one I have found in YouTube!!!

PLEASE make a video or videos explaining and using the reining tools with simple example to catch the idea of the function like in this video.

Thank you for taking the time to make this video!

[meruyertbekniyazova]

I've just finished the other course on Power Query, been sleeping all the time there and it seemed so boring and hard, happy to find out your lessons, I'm totally awakened in all meanings) Thank you for sharing your knowledge!

[serdip]

Absolutely BRILLIANT! Thank you for sharing this invaluable resource. It has been quite helpful in taking my proficiency in Excel to the next level.

[roberth.]

Outstanding presentation. Detailed and comprehensive in scope. Thank you for this training.

[skottjordan]

yes its really brilliant. You got the point between explaining the function and the sense behind in a really structured way. Greetings from Germany.

[harshababu]

Hello Alan, This is awesome. I am happy that I installed power query today and happened to see your wonderful video. Without a doubt you are an excellent instructor. I have shared this link to couple of my colleagues. Great preparation with hard work..appreciate it.

[andresff]

Amazing! Thank you for this well prepared tutorial. I am sharing this with some friends at the office.

[messiedoho]

Thank you Alan for this wonderful and powerful tutorial. You are such an awesome teacher. I understood perfectly every bit of the tutorial. Also, I hope to find the Power Pivot/Data Model tutored by you

[TheRancidMoose]

This was more than I was looking for, but I watched the whole thing and learned a lot about steps that I didn't know I needed to know.

[lochuynh]

Thank you for the extremely helpful video Simon, I just automated my first report and now can't wait to learn/do more of it =)))) Great job with the explanation!

[Dogpotter]

Brilliant video & well explained just getting to grips with power Query and loved this THANKS :)

[erictsang]

Simon
Your tutorial is very very comprehensive.
Appreciated
Eric

[susank]

Fantastic. So well put together. Each and every step is explained thoroughly. Thank you Mr. Alan.