Get & Transform in Excel 2016 – Excel

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.

Πηγή: Get & Transform in Excel 2016 – Excel

Power Query M Language | Office 365 content from SharePoint Pro

Did you know that with Power Query in Office 365, you can create basic M Language code and functions? The recommended practice is to let Power Query generate the code. In some situations however, it might be interesting to add your own custom touch.

Πηγή: Power Query M Language | Office 365 content from SharePoint Pro