This is called Get and Transform in Excel 2016 and 2019.

It is simply the best transformation and data manipulation tool for Power BI and Excel. The focus of this course is using Power Query in Excel.

If you use Excel to transform, enrich, append or merge your data using one or multiple sources then this tool is for you. Power Query delivers the greatest level of benefits and can be learned in the shortest amount of time when compared to using Excel Formulas and Visual Basic for Applications (VBA).

Define your data requirements once and use any time by refreshing your data. The result can be significant time saving and consistent reporting.