#EiEFreshTalk – M Code Recipes – Achieve more with Power Query by Ms. Celia Alves

  • 100% 100%

M Code Recipes – Achieve more with Power Query by Ms. Celia Alves

Certified Excel Expert, Business Solutions Developer, Certified Microsoft Trainer, MVPs

Watch Now:



Download Material:


Key Takeaways:

While the Power Query Editor already offers the user tools enough to solve many problems, there are some circumstances where it will be easier or faster to achieve the needed results if we play with the M code. We will look at some practical examples of very helpful M code snippets in Power Query in Excel.

About Speaker:

Celia Alves is a certified MOS Expert in Excel, Microsoft Trainer and develops complex solutions combining Excel, VBA, Power Query and Power Pivot to automate tasks, analyze data and model business situations.

She got her Licentiate and Master’s degree, both in Mathematics and Education from the University of Lisbon, in Portugal, and worked as a high school Mathematics teacher for two decades up to 2013 when she moved to Canada.

After re-skilling herself, Celia built a new career as an Excel consultant and trainer, ultimately founding her business Solve and Excel Consulting, serving companies in a wide variety of industries.

Celia is also a speaker and the founder and leader of the MS Excel Toronto Meetup Group. In 2020, she received the Microsoft MVP award in Office Apps and Services for her contribution to the community.

Hire us for your next corporate / institute session.
Need Help? Chat with us