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 [...]

Financial Modelling Meetup: Speed up your reporting processes with Advanced Filters and VBA

On June 23rd, 2020, I presented to the Financial Modelling [...]

By |2020-08-26T19:02:38+00:00August 26th, 2020|Events, Excel, Presentation in English, Training, Videos|0 Comments

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 [...]

By |2020-08-25T16:23:43+00:00August 25th, 2020|Excel, Office365, Presentation in English, Tutorial, Videos|0 Comments

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 [...]