PowerQuery is often used in combination with PowerBI and structured datasources.
But what if the only tool you can use is Excel. Yes, powerQuery is the same but there are some (strange) differences between the usage of Powerquery in PowerBI and Excel.
Follow me in the development of a solution in Excel with extensive PowerQuery usage where I share my learnings.

The video is not available to view online.