How to make VBA wait for Power Query
Making VBA wait for Power Query to complete refreshing [...]
How to Set Connection Only as Power Query’s Default Loading Destination in Excel
Power Query’s default loading destination in Excel is to [...]
Long live the King Excel and his beloved Power Query Queen!
My boss was very excited that day. He had [...]
How to share workbooks with data resulting from Power Query without allowing other users to refresh the queries
Power Query is all about creating a refreshable connection [...]
Dealing with dates prior to 1900 in Excel with Power Query
If you need to work with dates prior to [...]
Enable Background Refresh property in Power Query in Excel
In Power Query's properties, in Excel, we can find [...]
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 [...]
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 [...]