Microsoft outlines November 2016 updates for Excel 2016 Get & Transform and Power Query add-in

News

Reading time icon 1 min. read

Calendar icon Published on

by Radu Tyrsina 

published on

Share this article

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

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

The Office 365 team announced ten new features for Microsoft Excel 2016 today. The additions are focused on providing faster and easier data gathering and utilizing Excel for better insights of large amounts of information. The team said in their blog post that a lot of these were popular requests from users for data preparation.

The new features for Excel 2016 include:

  • 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.

Many of the new features can be accessed through the Get & Transform section. Office 365 subscriptions should download automatically. If you’re running Excel 2010 or Excel 2013, you’ll be able to download the Power Query add-in from the Microsoft Download Center.

Radu Tyrsina

Radu Tyrsina Shield

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time). For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web. Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they're looking for.