UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

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

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb