Group data in a list inside a cell with Power Query
In this video, I will demonstrate how we can group data in Power Query by one of the fields [...]
How to make paths dynamic so that Power Query connections work on Dropbox shared files
Case Scenario: You have a file on a Dropbox folder that contains Power Query connections, and you need those connections [...]
Get the data from the most recent file in a folder with Power Query
This video how you can connect an Excel file to a folder with Power Query and bring the data of [...]
Selecting all Columns of a spreadsheet with Power Query does not get dynamic
In this video, I will demonstrate that when you create a query with Power Query to look into the [...]
How to Fix broken Conditional Formatting Rules with VBA
Conditional Formatting Rules can easily be disrupted. The same thing happens with Data validation ranges. Part of the solution is [...]
WEBINAR – Fundamentals with Tips & Tricks of POWER QUERY in Microsoft Excel – Celia Alves
On April 12, 2020, I was honoured to present to the Pakistani Excel community about Power Query fundamentals. This session [...]