If you can excel in Excel, you certainly can do similar jobs with Python. You don't need dependency injection, semantic versioning (any version control at all!) or exception handling to write a script that turns your data from format A to format B and generates a summary. Most people can probably learn enough Python to do that in two or three weeks.

There is a large gap between what professional programmers are expected to know and the minimum skillset needed to write programs that are useful for one specific task. Many people in your typical office would benefit from the ability to (partially) automate some of the tasks they do every day. Implying that they have to invest countless hours to learn how to do that is part of the problem.