What is Power Query?

What is Power Query, what is it used for, where do you use Power Query?

If you're asking these questions then here is a brief introduction with 3 examples of Power Query use cases. Learning Power Query could change your life for the better.

It's key to better Excel reports and Power BI

Follow me on LinkedIn

Twitter

Access Analytic Training

[JuanIArana]

Brilliant explanation Wyn. I find PQ knowledge is a must nowadays! Thanks for sharing

[AlphaWatt]

SO glad to have found your channel! A career change has me switching gears from creating models with Python to exclusively Excel. Your videos are getting me quickly up to speed. Thank you!

[IvanCortinas_ES]

Bravo Wyn! Brilliant explanation. All your videos are very useful. Thank you.

[wayneedmondson]

Hi Wyn. Awesome video! Even when it is review, I pick up tips and tricks from you. Thanks for all of your informative and inspirational videos, tutorials and blog posts :)) Thumbs up!!

[petecardona]

AWESOME explanations mate! Simple yet very insightful...

[mdms]

The content and explanations are simple and straight forward. Glad I found your channel. Learning more from your videos then 6 months of short course on MS Excel. Cheers.

[anilpothuru]

Matter is too clear
Love from Indian🇮🇳
🤘🤘

[mrsimonexeter]

Great tip with using a named cell to stop a table being generated when getting data from a cell on the current workbook

[RaisingTheAnte]

I absolutely love Power Query. It's been a real game-changer in the way I've been able to consolidate data from a bunch of reports and shoot it out to my boss's in a way that they can understand. LOVE YOUR VIDEOS!

[jusuflazami]

Super Duper Amazing explanation, clear and concise!! Awesome!!

[louism.]

Thank you so much for this, what impressed me the most is converting the columns of dates to rows, something that is a massive headache to do on Excel using formulas.

[joshuawilliams]

Thanks for this, really useful for my work ands will tell my coworkers about this channel so they can get their training in!

[a.achirou]

Excellent explanation and great teacher !!

[zovi-kanu]

above brilliant you make analysis easy

[Devilchild]

Most useful. In fact incredibly useful. I have been taking Mynda Treacy's courses for a year and I just wanted a different perspective, not because she is inadequate, but because I get information overload when it all comes from the same person. I must like her work and her style because I have subscribed to further (Paid) courses!

Your tutorials, however, do not just offer a refreshingly different perspective, but they add a new layer to my understanding. Well done. Brilliant presentations and great style. So many other Excel trainers are just so boring. Too boring to listen to in fact!

I have subscribed to your channel and will investigate your company's offerings in more detail.

What is it about Australia that makes two extremely talented people emigrate there? (Three if you count her hubby, Don) You are the only Welshman Excel VP that I have ever come across and you live in Aus!!!!

Later on, I will come back to you about Excel Solver. As far as I can see from the records of the Operational Research Society (I am a member) I am only one of two or three Excel consultants in the UK who know what the hell it is and also knows how to use it!!

[Karen-bmrj]

I'm busy teaching myself power query, and your videos are very useful and helpful.
Essential viewing 🙂

[salehmohamed]

Thank you sir so much for creating this video. Very well explained and useful for anyone needs to learn Power Query. You deserve a Noble Prize.

[despaid]

Just making a career change into the world of data analytics and this tutorial was amazing! This will be a total game changer for how I clean up reports and combine large files. You make it so easy to follow!! Thanks bunches!

[myxammg]

You are great, you are not just person explain I think you are school for learning, thank you and please don't late to make new videos

[OlBelkan]

You are amazing! Thank you! I work with excel every day and I haven't known about it. I finished school 9 years ago, and I thought I was a pro 😅