Power Query Examples

Compare Two Tables with the Power Query in Excel – 2 Examples

There's a dataset showcasing students' IDs and names, and another one containing the Passed Students' Records in Term 1 and Term 2. To ...

Dealing with Tables with Changing Headers in Power Query

As in real time it happens a lot, we tend to update our original data source a lot, during that period, we may alter the column Header a bit inside ...

How to Split Column in Excel Power Query: 5 Easy Methods

Method 1 - Using Delimiter Command to Split Column in Excel Using Power Query Step 1: Select your entire data range from your dataset. Select ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo