re: Learning Macros to further develop efficiency skills

You may want to look into a BI tool like Tableau or Power BI if you are just wanting to create reports for end users. We’ve started using Power BI instead of excel reports and the users have been much more receptive to it.

Regarding macros, I’ve written a few simple macros to automate processes and really just googled what I was looking for. There is a ton of code out there that you can just copy and paste, maybe change a few minor things, and be on your way. I never took any courses, just read stuff online.