Power Query is the tool used to import, clean and shape data in Excel. If you’ve never heard of Power Query and want to get familiar with what it can do. It first appeared in Excel 2013 but was made available only as an add-in named Power Query. From Excel 2016 and in Microsoft 365, it is available directly within …