Blog2019-01-31T13:17:09+00:00

Células em Quarentena #12 – Pontos de Atenção ao Unificar Dados no Power Query com Célia Alves

By |August 26th, 2020|Events, Excel, Power Query, Presentation in Portuguese, Training, Videos|

No dia 13 de Maio de 2020, tive o prazer the apresentar no canal Karen Abecia - Eu Juro, Funciona!, [...]

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

By |August 26th, 2020|Events, Excel, Presentation in English, Training, Videos|

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

By |August 26th, 2020|Events, Excel, Power Query, Presentation in English, Training, Videos|

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

By |August 25th, 2020|Excel, Power Query, Presentation in English, Tutorial, Videos|

This video is about finding a way to calculate with Power Query in Excel the longest set of consecutive days [...]