Enable Background Refresh property in Power Query in Excel
This video is about the "Enable Background Refresh" property in [...]
Células em Quarentena #12 – Pontos de Atenção ao Unificar Dados no Power Query com Célia Alves
No dia 13 de Maio de 2020, tive o prazer [...]
Mão na Massa com Célia Alves e Viviane Martins
No dia 16 de Abril de 2020, tive o prazer [...]
Financial Modelling Meetup: Speed up your reporting processes with Advanced Filters and VBA
On June 23rd, 2020, I presented to the Financial Modelling [...]
Excel London Meetup – Power Query Tips and Tricks – Celia Alves
This is a recording of the April London Excel Meetup [...]
The Longest Absence in a Period with Power Query and M Code in Excel
This video is about finding a way to calculate with [...]
How to prevent two users from editing the same Excel file at the same time with VBA
In this video, I demonstrate a way to work around [...]
Group data in a list inside a cell with Power Query
In this video, I will demonstrate how we can group [...]
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 [...]
Get the data from the most recent file in a folder with Power Query
This video how you can connect an Excel file to [...]