Get & Transform in Excel 2016 and Power Query Add-In

Query in Excel 2016

(Source)

Get & Transform is a new set of features in Excel 2016 that provides quick and easy data gathering and shaping capabilities. Learn more with Microsoft’s Getting Started with Get & Transform in Excel 2016 guide. Since its release, Microsoft has continued to make updates to the Get & Transform feature set for Office 365 subscribers. Excel 2010 and Excel 2013 can also take advantage of these new features and updates by downloading the latest Power Query for Excel add-in. Learn more about Power Query with Microsoft’s Introduction to Power Query for Excel.