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

Reading time icon 1 min. read


Readers help support MSpoweruser. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more

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

Excel 2016 comes with 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 eight 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:

  • Enhanced SAP HANA connectorā€”allow multi-select of values for variables and parameters.
  • Enhanced OData connectorā€”option to import Open Type columns from OData feeds.
  • Enhanced Access DB connectorā€”new Select Related Tables button to ā€œā€ in the Navigator dialog.
  • Option to generate Step Names in English within the Query Editor.
  • Description for Query Steps within the Query Editor.
  • Extract Week, Day or Month name from a Date/Time column from the Query Editor.
  • Merge Dates and Times into a Date/Time column from the Query Editor.
  • Extract Start/End of Hour from a Date/Time or Time column from the Query Editor.

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

User forum

1 messages