What is Power Query?
Power Query is a data transformation and data preparation engine.
source: https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query
This amazing tool comes embedded into Excel and is still quite unknown by many Excel users.
In this walkthrough video, I am giving you a quick intro to the tool and an explanation of the relationship between Excel, Power Query and also where Power BI fits into the picture.