Former Employee

Excel 2016 includes a powerful new set of features based on Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.


Today, we are pleased to announce four new data transformation and connectivity features that have been requested by many customers.


These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.


These updates include the following new or improved features:

  • Conditional Columns.
  • Column type indicator in Query Editor preview column headers.
  • Reorder Queries and Query Groups inside Query Editor via drag and drop gestures.
  • Query Management menu in Query Editor.


Read more on Office Blogs.