Another issue is that there is a massive difference between casually knowing excel formulas and being familiar with power query/power pivot/etc cetera. I think

Another issue is that there is a massive difference between casually knowing excel formulas and being familiar with power query/power pivot/etc cetera. I think someone well versed in DAX expressions and other portions of excel could probably handle a few midsized things, that said, if your dataset is gigabytes then obviously you're going to need a specialized database or custom programming.