/Celia Alves

About Celia Alves

Celia Alves is a Microsoft MVP & Certified Excel Expert, specialized in developing highly complex solutions for Businesses combining VBA, Power Query and Power Pivot to automate tasks, analyze data and model business situations. She is originally from Portugal where she got her Bachelor and Master’s degrees from the University of Lisbon, both in Mathematics and Education and thought Mathematics in middle and high school for almost 2 decades. In 2013, Celia moved to Canada, where she re-skilled herself and built a new career as an Excel consultant. Celia is also the founder and leader of the MS Excel meetup group in Toronto.

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