Power of Filters

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. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign […]

Recommended Power Query Settings

One should never underestimate settings in Power Query. So let’s have a look on few recommendations which can save you lots of pain in future. This articles covers only the most relevant settings (not all). Settings not covered in this articles are usually self-explanatory. ***Tip: Have a question? Ask in the comment section below or […]

Free 404 URL Checker

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! ***Tip: Have a question? Ask in the comment section below or in this Facebook […]

The Very First Post

So what is this page going to be about? About leveraging MS Excel knowledge in PPC Search industry. I will share tips & tricks on various topics – from one-click campaign build up to one-click refreshable reports. The key tool I will be using is Power Query extension for Excel. It is a free extension […]