Integrated MRP solutions from the experts >

Off the shelf professional e-Commerce web store that grows with you

Get the Office 365 - Free Trial! Try now for 1 month with no obligation.

DC Blog

July 2016 Updates for Microsoft Excel in Office 365

July 2016 Updates for Microsoft Excel

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 New Excel Power Query Connectivity and Transform Features

The following are a list of the new connectors and transformation features that Microsoft have released for Excel 2016:

Read More