Power Query is one of the advanced Excel skills that you need to learn and, in this tutorial, you will be exploring power query in detail and will be learning to transform data with it.

In Power Query, if you want to create an IF statement, there’s a specific option to help you write it without a formula. For example, below is a list of numbers (100) in column A. You need a new …

Using formulas in Power Query is like formulas in Excel; you only need to know the right function or the operator to use. In the next part of this tutorial, we will learn to use a function to get the desired result …

In this tutorial, I’ll show you how to set up this small but powerful way to extract data using Power Query. Step 1: Create a Query to have a Dynamic Value for the Last N Days

In Power Query, you can use the Text.Contains a function that you can use to test whether a sub-string is in the string or not. Apart from this function, we can also use the IF statement to test for a …

In Power Query, if you want to get today’s date (current date in a column), you need to add a custom column by using two functions together. Note: Use the formula DateTime.Date ( DateTime.LocalNow …

VLOOKUP is one of the most popular functions in Excel and there’s no doubt about it. You know this from the very beginning of your Excel journey. But today I have something new for you, and you …

Power Query allows you to remove duplicates from the data, just like in Excel. And in this tutorial, we will learn to remove duplicate values from the data.

In Power Query, there are multiple methods that you can use to concatenate values (numbers and text). And in this tutorial, we will learn to use these methods. Below we have a list of first and last names in …

And to unpivot data, the best way is to use the POWER QUERY. So today in this post, I’d like to share with you simple steps to convert a crosstab data into a table using POWER QUERY’s unpivot option.