Microsoft Excel Tutorials
For this tutorial, I have the following set of data that is given below. Currently, the headers are not meaningful to me because it is written as Column1, Column2, Column3 so I want to eliminate them …
Continue Reading about How to Use First Row as Headers Using Power Query? →
Excel has so many formulas but only a few of them can be used in M. For instance, Excel’s FIND formula to find a specific character in the text will not support in M. Here, I’ll tell you to step by …
Continue Reading about How to Replicate Excel’s FIND Function with M in Power Query? →
Keep Duplicate Records Using Power Query From Excel 2016 has a new set of features known as Get & Transform which was known as Power Query in Excel version 2010. It provides you with a platform …
Continue Reading about How to Keep Duplicate Records Using Power Query? →
Remove Columns Using Power Query or Get & Transform Excel in 2016 has a new set of features known as Get & Transform which was known as Power Query in Excel version 2010. It provides you …
Continue Reading about How to Remove Columns Using Power Query? →
Import Data from Text Excel In 2016 has a new set of features known as Get & Transform or in earlier versions, it is known as Power Query. It provides a platform to perform a series of steps to …
Continue Reading about How to Import Data from Text Using Power Query or Get & Transform? →
Import Data from CSV Excel in 2016 has a new set of features known as Get & Transform or in earlier versions, it is known as Power Query. It provides a platform to perform a series of steps to …
Continue Reading about How to Import Data from CSV Using Power Query? →
