26 July 2016
Excel’s Power Query technology provides fast and easy data gathering and manipulation capabilities, ideal for calculations and reporting based on databases. Accessed through the Get & Transform section on the data ribbon.
Microsoft have now released 12 new data transformation and connectivity features all available as part of the Office 365 regular updates. Even if you are using older versions of Excel, ie Excel 2010 or Excel 2013 you can take advantage of the updates by downloading the latest Power Query for Excel add in.
The following are a list of the new connectors and transformation features that Microsoft have released for Excel 2016: