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.
There are several options to fix slow Mac performance. If you want to check for issues with memory start by opening Activity Monitor. Pick the processes that are causing the issue and then click to quit. If the program takes up too much memory, you can close it then try it again. Alternately, you could utilize the System Memory tab to check for any process that is slow that are running in your Mac.
There’s another reason for slowness on your Mac. It is recommended to close any application that uses too much CPU. To do this, open the Activity Monitor and press”X” or the “X” button underneath the tiny window’s buttons. You can use Google to find apps that are consuming the most CPU power but you’re not sure speed my mac of what apps are. You should be able identify which programs have a negative impact on your Mac’s performance.
The performance of your Mac could also be slowing down in the event that it’s loaded with many applications. The operating system can run slower when you run too many programs. You can try deleting any files you’re not using or move them to another drive. If you’re not sure what’s causing the problem You can try opening up the Activity Monitor and looking at the complete list of processes that are running within your Mac. Some errors will be apparent – they are an indication that your computer has too many running all at the same time.