IF Function in Power Query for Advanced

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** In the previous article, we looked at IF function basics. Today, it is time to look at more advanced stuff. Spoiler alert: nested formulas (aka “vnořené funkce”) included. For all the samples, we will be using the following image as basis: Text Editor Is Better than Native […]

Using Google Sheets as Data Source in Power Query

***TIP: Subscribe to our newsletter. Don’t miss any new content.** 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 […]

Free 404 URL Checker

***TIP: Subscribe to our newsletter. Don’t miss any new content.** Frequently, we are building  PPC search campaigns pointing to many different URLs.  How cool would it be to be able to check our dataset for 404 pages BEFORE we upload to AdWords, to Bing, or to Sklik? Read more to find out! Situation: You just build […]