Creating better tools is not the answer, reducing the operation burden of deploying said tools is.
The majority of people using Excel in a business environment at least sometimes use those functions, even if most don't actually understand them.
There is just about always someone in the office/department who "knows excel" well enough to use the Macro Recorder and occasionally tweak something in the code, and that's enough. So they get the task of automating the thing in the spreadsheet and then everyone else uses it.
I've seen it dozens of times. Someone shares the wrong excel file then others keep working with outdated data. Or maybe they all share a file in Dropbox but someone didn't sync for some reason and kept working and generating changes over an old file.