> Now, there ARE people who learn Excel but refuse to go further... Since Power Query was first included by default in 2016, I've introduced tens of regular Ex

> Now, there ARE people who learn Excel but refuse to go further... Since Power Query was first included by default in 2016, I've introduced tens of regular Excel users. Because there's no way to work cell by agonizing cell, there's a mental tension for a few minutes then usually the concept of working with fields and sets clicks into place so well you can practically hear it. Even if they never use PQ again, they often change how they use spreadsheets for the better. If you're really lucky they don't just start using PQ, they find the advanced editor and start doing some basic fiddling around. While it's fair to criticize M [0] as a niche language that only exists in a tiny corner of one company's data modeling features, it's also what finally motivated me to learn functional programming. That accessible step by step ramp from introduction to functional language data modeling in a common office tool is an underrated juggernaut of a feature. [0] https://docs.microsoft.com/en-us/powerquery-m/ https://docs.microsoft.com/en-us/powerquery-m/