How to Connect Excel to AdWords with Power Query

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** Have you been dreaming of how smooth it would be to have Excel connected to AdWords? There might be a reliable workaround solution for you. This article is for more advanced users but don’t be scared – why don’t you just become advanced user by trying all of […]

Power of Filters

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** Filters are important part of every Power Query project and should not be underestimated. Let’s have a look on how to easily build & optimize your filters. As usual, the difficulty will increase with every following example.  Level 0: Selective Filters The easiest option to filter the […]

List Functions: an Elegant Way to Manipulate Text

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

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 […]

FREE Email Generator

***TIP: Subscribe to our newsletter. Don’t miss any new content.*** Trying to create X combinations of possible email addresses when you know names & domains? Generate email combinations with one click! Here is a FREE tool for that. You can use it e.g. for building your newsletter lists or customer match email  lists. You need Excel […]