About Celia Alves

Celia Alves is an awarded Microsoft MVP and Certified Excel Expert, specializing in building highly complex solutions combining VBA, Power Query, and Power Pivot to automate Excel reporting procedures. By combining her experience as an Excel Consultant and two decades as a Mathematics teacher, Celia created a training program to pass on her knowledge and techniques to those who want to stop wasting time in Excel with repetitive and meaningless tasks. Celia is also the founder and leader of the MS Excel meetup group in Toronto, with over 3,000 members worldwide.
FacebookXLinkedInEmail

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

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

By |2023-06-21T16:20:20-05:00August 26th, 2020|Events, Excel, Presentation in English, Training, Videos|0 Comments
Read More

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

By |2023-03-23T11:26:00-05:00August 25th, 2020|Excel, Excel Tutorial, Office365, Presentation in English, Videos|0 Comments
Read More

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

By |2023-05-23T11:36:29-05:00August 25th, 2020|Excel, Excel Tutorial, Power Query, Presentation in English, Videos|0 Comments
Read More

Selecting all Columns of a spreadsheet with Power Query does not get dynamic

In this video, I will demonstrate that when you [...]

By |2023-05-23T11:43:13-05:00August 25th, 2020|Excel, Excel Tutorial, Power Query, Presentation in English, Videos|0 Comments
Read More
Go to Top