First you need to understand that this is a minority position. Despite the last decade or so of "software eating the world", most line-of-business type people are not programmers, and couldn't write a python script if their life depended on it. I don't say this to criticize; I couldn't put together a corporate financial statement if my life depended on it either. Not everyone has the professional time (or desire) to learn to program.
But if you have this tool, Excel, that is critical to your job in many non-programming-y ways, but can manipulate data in ways that programmers would usually use code to accomplish, well... that's great, you use it, and are able to do your job better and more efficiently. And it flows naturally from the skills that you already have.