I have to maintain and support lots of those Excel "solutions" and the users actively block learning any software practices.

We are talking about people that still use spaces to right align a date in word or create the table of contents by hand. The least that they want to be is programmers.