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.
Good God please use xlookup. We have some old school people that still use vlookup and refuse to convert their ranges to tables, it drives me crazy.
I still use index/match for multiple lookup returns (or is it sumifs I can’t remember?) But I do a lot of work in BI and it’s much more intuitive for me in DAX/M.
I kinda get it, I had an overnight job at home Depot in and a hospital all thru college and for a while after. I can keep a good sleep schedule with habits and routine, but if I can’t keep that up (illness, stress) I still revert to overnight schedule.