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

Home » Office » Office 365

Reading time icon 1 min. read

Calendar icon Published on

by Pradeep Viswav 

published on

Share this article

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 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 six 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:

  • New OLE DB connector.
  • Enhanced “Combine Binaries” experience when importing from any folder.
  • Maximize/Restore buttons in the Navigator and Query Dependencies dialogs.
  • Support for percentage data type.
  • Improved “Function Authoring” experience.
  • Improved performance for OData connector.

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

More about the topics: Excel, Excel 2013, Excel 2016, Get & Transform, microsoft, new features, office 365, Power Query add-in, update, updates

Pradeep Viswav

Pradeep Viswav Shield

Software and Services Expert

Pradeep is a Computer Science and Engineering Graduate. He was also a Microsoft Student Partner. He is currently working in a leading IT company.