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 the apresentar no canal Karen Abecia - Eu Juro, Funciona!, [...]
Mão na Massa com Célia Alves e Viviane Martins
No dia 16 de Abril de 2020, tive o prazer the apresentar no canal VBA na Veia, de Viviane Martins, [...]
Financial Modelling Meetup: Speed up your reporting processes with Advanced Filters and VBA
On June 23rd, 2020, I presented to the Financial Modelling meetup group in Sydney, organized by Danielle Stein Fairhurst. I [...]
Excel London Meetup – Power Query Tips and Tricks – Celia Alves
This is a recording of the April London Excel Meetup (April 20, 2020), organized by Alan Murray, where three speakers [...]
The Longest Absence in a Period with Power Query and M Code in Excel
This video is about finding a way to calculate with Power Query in Excel the longest set of consecutive [...]
How to prevent two users from editing the same file at the same time with Excel VBA
In this video, I demonstrate a way to work around the issue of Windows that allows more than one [...]