Get the data from the most recent file in a folder with Power Query
This video how you can connect an Excel file to [...]
Selecting all Columns of a spreadsheet with Power Query does not get dynamic
In this video, I will demonstrate that when you [...]
How to Fix broken Conditional Formatting Rules with VBA
Conditional Formatting Rules can easily be disrupted. The same thing [...]
WEBINAR – Fundamentals with Tips & Tricks of POWER QUERY in Microsoft Excel – Celia Alves
On April 12, 2020, I was honoured to present to [...]
Dynamic Filter with VBA
In this video, I will show how to create [...]