Excel 2016 includes a powerful set of features based on the 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 three new data transformation and connectivity features that have been requested by many customers.
Read about it on the Excel blog.