Excel Weekend 7 - M code tips to achieve more with Power Query - Celia Alves, MVP

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. We will look at some practical examples of very helpful M code snippets in Power Query in Excel.

Celia Alves, MVP (Canada).

Celia Alves is Microsoft MVP, certified MOS Expert in Excel, Microsoft Trainer and Business Solutions Developer. She loves to design and build complex solutions combining Excel, VBA, Power Query and Power Pivot to automate tasks, analyze data and model business situations. Celia got her Licentiate and Master’s degree, both in Mathematics and Education, from the University of Lisbon, Portugal, and worked as a high school Mathematics teacher for two decades up to 2013 when she moved to Canada with her family. After re-skilling herself, Celia built a new career as an Excel consultant and trainer, ultimately founding her business Solve and Excel Consulting. Celia is the founder, leader and a speaker of the MS Excel Toronto Meetup Group, and a content creator on YouTube.

Subscribe:

#ExcelWeekend #EW7 #ExcelTurbo #Data #Excel #MicrosoftExcel #MSExcel #Technology #Tutorial #DataCleaning #Mlanguage #PowerQuery #CeliaAlves #SolveAndExcel #MVPBuzz

[dyglesias]

Very powerful tips, yet so easy to implement

[allisonp]

Wow! I am basically self-taught using Power Query and I had no idea I could have a step like this in the middle of the query. I had been creating separate queries just for a single value and then adding to a table when needed. This of course would not have worked for your example since there is not a separate query for each table. Such wonderful news! Thank you!

[wayneedmondson]

Hi Celia. An awesome lesson! Great new tricks to add to my Power Query toolbox. Thanks for sharing :)) Thumbs up!!

[lourdessuarezvillasmil]

You have a remarkable ability to explain. Thank you very much.

[johnborg]

Thanks Celia. I just subscribed to your channel. That was interesting!! :) :) and congrets on your MVP certification.