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