Microsoft Excel 2016 New Get and Transform feature

August 20, 2017

In my Complete Microsoft Excel Course on Udemy, Excel from Beginner to Advanced, I recorded some instruction on working with Microsoft Excel’s powerful Power Query and PowerPivot Add-Ins. When Excel 2013 was released, Microsoft made some changes and the 2 Add-Ins are no longer available on the home and student releases. In the 2016 release of Excel, Microsoft add the functionality that Power Query offered directly into the software without the additional Add-Ins needed.


Microsoft Excel’s Get and Transform


Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform enables you to connect, combine, and refine data sources to meet your analysis needs. These features are also used in Power BI, and in the Power Query Add-In available for previous versions of Excel. ” – Microsoft


See Excel 2016 Get and Transform in ACTION!



16 Minute Video


Download the exercise file to practice using Excel’s Get and Transform feature: CustomerOrders-GetAndTrans-01.xlsx

Please reload

Recent Posts

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb