What is Power Query? 

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

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

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!!

AWESOME explanations mate! Simple yet very insightful...

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!

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.

The way you present seems precious!

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

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!

Can't wait to binge on these 👍👍👍

Excellent explanation and great teacher !!

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

Matter is too clear Love from Indian🇮🇳 🤘🤘

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!

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

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.

Many thanks, Wyn.

above brilliant you make analysis easy

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

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!!

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

AWESOME SESSION SIR LEARNT A LOT AND WOULD LOVE TO LEARN MORE FROM YOU. 😇

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.

Awesome, great. Thank you.

Vert useful presentation and very insightful

Amazing explanation

Awesome, thanks for sharing.

Great video. Thanks.

mashallah....helpful for every one.

TYVM sir, GBU and you are awesome

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 😅

Thank you sir

Awesome video!!

Thanks you. Very clear

Excellent!

Thank you

sir I am baby in power query now i dive into pole with you.....great sir

No1 "Mr.M.

GOD bless you !😀

Thanks for this video. It was very helpful. It would be great if you mention where I can find the files that you used in this video for practice. By the way you have a new subscriber.

Beautiful summary, Wyn! How hard was it for you to decide what to show about Power Query in this video?

Superb explaination. I want to load 7 different structured sheets into one consolidated file, then clean and transforming to load into SAP SAC. What should be my general steps? This work is repetitive every month. Which functions and software will help me most?

Great

I am astounded by the way you present these things. I am using Excel since 2010 but was always afraif of Power Query and Pivot Table. They seemed complicated, until now. However, is it possible to share the datasets you use so that I can practice?

great content as usual, are there any exercise file to follow along?

Hi Wyn. Thank for you the video. A question do you recommend switching manual calculations in excel? I'm using power query to import multiple excel tables into an excel file and use those tables as source for a summary report. Several array formula/lookups/sumifs/filter functions on imported tables. I experience a slow refresh import from power query. Good to mention that the files are coming from an excel on sharepoint. Do you have any other recommendations to speed up the refresh ?

to some extent, PQ provides a replace of some fuction of VBA.

Hello. Your explanation is wonderful. I have a an issue which I can't find any solution for it online. I have a table with millions of rows in power query with multiple columns. Is it possible to know if the items in column1 for example exist in column2 no matter if they are not located on the same rows? i want to return true or false next to each item from column1 so i can use this in my analysis whether in Excel or Power BI.

i'm stuck on adding a calculated date column. I'd like to add *fixed text* + CurrentMonth + CurrentYear (Month / Year calculated by formule). Any idea how to do this?

Hi sir I have a query like I have a single excel sheet in a excel file in that single excel sheet I have multiple tables with different data and header is it possible that I make a relationship with those tables and make a DASHBOARD in power bi

Is there an easy way to create a copy of file without Power Query? If I wanna share my file with 3rd party, but don't want them to have a query in the file. Is there a good and safe way to do it? So I would not remove query and oversave original file by accident?..

Does it have to be the same Excel sheet for PowerQuery to work where PowerQuery steps? or Is this Query saved in every Excel Sheet we open from then onward we write this query How does that work?

Would have been good if the practice file could also have been shared

Could u upload the practice file? Thank you ❤

please can you give me a road map for data analysis to study from your channel?

Hi....Sir I have a serious problem while transform and edit pdf file from our Accounting Program "Pioneer"......PDF Accounting Ledger statement while converting to excel showing : Debit & Credit side showing in different columns . I mean in 1st page "Debit" shown in column 'A" but second page "Debit" Shown in "B" column so on.......same way "Credit; coloumn also shown in difference coloumn in each page. I means not in one line thought-out the sheet. Pls help me to sort out this issue ....

Many Thanks but where's the Workbook to Practice ?

hey, can you give us the data you have used in your video?

Excellent transformation in a sec!. @AccessAnalytic where can I find these sample files for more of a practice side.

Excellent transformation in a sec!. @AccessAnalytic where can I find these sample files for more of a practice side.