Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 What versions of Excel include the Get & Transform (Power Query) experience? Excel 2016 The Get & Transform (Power Query) experience is available in all Excel 2016 plans on the Data tab under the Get & Transform section. Windows snipping tool for mac. It is available with basic and advanced features depending on your version. Basic business analytics features • Available with any or Office 2016. • Import data from private files, databases and websites: • CSV & Text, Table/Range, Excel workbook, XML, JSON, Folder, Access, SQL Server, Web, OData feed, Analysis Services, Facebook, ODBC, OLEDB, and Microsoft Query. Advanced business analytics features • Available with, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone. • In addition to basic business analytics features, you can also import data from corporate, big-data, and cloud data sources.