09 August 2017
One of the benefits of Office 365 is the continual updates that they are providing in functionality, be it user experience or administration tools. See the video with Jim Naroski, which covers the following areas:
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: