M Code Recipes – Achieve more with Power Query by Ms. Celia Alves
Certified Excel Expert, Business Solutions Developer, Certified Microsoft Trainer, MVPs
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.
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.