I’m not a programmer by trade but I learned some python and VBA to automate some of the things I do every day. Any time you’re doing some manual shit and think “there’s gotta be a better way” there probably is - just Google how to do that one thing and you’ll build up your knowledge over time.
It’s up to you to decide if you tell your boss or not. I chose to and took on some extra duties along with extra pay so it worked out for me but it’s a small business with a high value on productivity.