Excel Power Query is a data connection and data transformation application that enables users to import and reshape data from various sources, including Excel workbooks, databases, and online services, into a format suitable for analysis and reporting. Built in to Excel 365 since 2016 it’s a powerful tool for extracting, transform and display using Excel Charts and Pivot tables.
