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

From time to time, you need to work with data which is living somewhere online so let’s have a look on how Power Query can help you. I will be describing various scenarios which I personally tested multiple times. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can […]

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. How to Navigate to Power Query Settings In Power Query, follow […]

Frequently, you will find yourself creating a same IF function (or any other function) over and over and over and over… So why don’t we just create the function ONCE and then keep re-using this function over and over and over…? Read more to find out how to build your own custom function exactly fitting […]

Looking for Excel training for PPC? Try Power Query instead and stay miles ahead of your competition. Power Query (aka Get & Transform) is a set of Excel features which can totally replace standard Excel which is slow, inefficient and too complicated to use. Power Query (Get & Transform) is an official Excel extension built […]

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

In the previous article, we looked at IF function basics. Today, it is time to look at more advanced stuff. Spoiler alert: nested formulas included. For all the samples, we will be using the following image as basis: A sample Excel file with applied IF functions can be downloaded here:   Text Editor Is Better than […]

The best function of all times. IF function. Everyone has heard about it but only few can use it. So how does IF function work in Power Query? Well, there is a button for that. As usual. You will be able to complete basic IF conditions purely with the “IF function help wizard”. For the […]

I often get questions such as “Is Excel function XYZ available in Power Query as well?”. Well, you are now about to find out. Let’s focus on functions which we frequently use in the PPC industry. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up […]