M code tips to achieve more with Power Query- Solve and Excel

Excel Weekend 7 – M code tips to achieve more with Power Query

On June 12, 2021, I presented M code tips to achieve more with Power Query. We looked at some practical examples of very helpful M code snippets in Power Query in Excel.

We know that the tools offered by Power Query Editor are enough to solve most ETL problems. However, some business cases present challenges that are solved faster if we make slight amendments to the M Code that Power Query generates for us through the buttons we click in the user interface.

The Excel Weekend is a full-weekend event that brings together the Excel community to learn and celebrate the passion for the most used spreadsheet software on the planet!

49 Excel experts from 21 different countries presented the newest and best about Excel for YOU. Check the other talks on the event playlist

Learn how to automate your Excel reports
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists
Check other posts about Power Query and Excel in this Blog,

About the Author: 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.