Yeah, Excel is crazy flexible so it's no wonder that where ever there isn't a designated application for something, people fall back to Excel. I think it's a good platform to introduce dev tools in, all those small ad-hoc use cases can be served much better with some serious dev tools at hand.
Reminds me of gunpowder - very powerful, very dangerous and very useful.