Microsoft announces ten new data transformation and connectivity features for Get & Transform in Excel 2016

Office-2016-for-Mac-is-here-2

Excel 2016 comes with a set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform allows users to connect, combine, and refine data sources to meet their analysis needs. Microsoft today announced ten new data transformation and connectivity features for Get & Transform that have been requested by many customers.

These updates include the following new or improved data connectivity and transformation features:

  • Web Connector—UX support for specifying HTTP Request Headers.
  • OData Connector—support for “Select Related Tables” option.
  • Oracle Connector—improved Navigator preview performance.
  • SAP HANA Connector—enhancements to parameter input UX.
  • Query Dependencies view from Query Editor.
  • Query Editor ribbon support for scalar values.
  • Add custom column based on function invocation.
  • Expand & Aggregate columns provide support for “Load More” values.
  • Convert table column to a list—new transformation.
  • Select as you type in drop-down menus.

These updates are available for free as part of an Office 365 subscription. Read about all these improvements in detail here.

Some links in the article may not be viewable as you are using an AdBlocker. Please add us to your whitelist to enable the website to function properly.

Related
Comments