There is lot of potential to save time in repetitive data cleaning and formatting using this. Power Query is one of the most powerful tools added to Excel. It uses the M Language to record each step we make and lets us to modify those steps in way we want. It can link to external data from many different types of sources into local data model in Excel or display them as tables. However, with Excel 2016, the tool is also commonly referred to as ‘Get and Transform’. This tool is generally referred to as ‘Power Query’ when searching for information online.
