There are a lot of Excel Power Query tutorials on YouTube. Below is just a short list of a few that I have found. The purpose of Power Query is to automate the getting and the cleaning of data. I recommend learning Power Query becasue as a data professional, it saves you time. Also, it does not require programming.
How to easily automate boring Excel tasks with Power Query! It is by Mynda Treacy at MyOnlineTrainingHub. This video is about 17 minutes and moves along quickly. Every step is shown. In the example, there is a folder containing three Excel files with data for the last three years. She uses combine and transform tools. The data needs some work, such as converting the first two rows into one row (for the header), splitting a column into two columns using a delimiter, add two calculated columns (total sales and the difference between the order date and the shipping date) and change the salesperson column by extracting the first name from the full name. Finally she filters the data to have only those that have a specified priority. A couple of other housecleaning tasks are need and then after selecting the columns and the Transform tab, she clicks detect data type. At 13:20 she is ready to close and load. She loads it into a Pivot Table Report and also creates a simple line chart. Finally, and this is where Power Query really shines, she adds more data to the folder and clicks refresh to see the updated table of data and the updated chart.
How to use Microsoft Power Query is a YouTube video by Kevin Stratvert. It is a 16-and-a-half-minute video. In this example, we are also working with sales data. In fact is is very similar to the other video mentioned above in this post. In this video there are fewer transformations.
Interactive Excel Dashboards with Power Query and Power Pivot – FREE Download This one is an advanced one that is fast paced and is about an hour long. This one is by Mynda Treacy at MyOnlineTrainingHub.
How to build Interactive Excel Dashboards that Update with ONE CLICK!. I have included this link partly because it is very popular with over 8 million views. Also, she talks a bit about the tabular data format, which is a critically important topic.
Get Multiple Files Containing Multiple Sheets with Power Query is a YouTube video by Mynda Treacy at MyOnlineTrainingHub. She has three Excel files, one for each year. Inside each of the Excel files there are 8 sheets, one for each product category. For example there is Beverages, Condimets, Dairy and so on. Each sheet contains two columns: Product and Sales (in dollars). The data is not in an Excel table nor is it in a named range. Also there is no date in the data. The date is part of the file name. The goal is consolidate each sheet and all three files into a single table.