List Functions: an Elegant Way to Manipulate Text

List functions can become your favorite set of functions if you often need to manipulate text (aka “keywords”). You are now probably wondering what “list” function even means in Power Query. Basically, a “list” is a special object whose elements can be easily manipulated separately. ***Tip: Have a question? Ask in the comment section below […]

Using Google Sheets as Data Source in Power Query

Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets files where multiple people can work at the same time. You would like to use this reference sheet as data source in Power […]