
Appreciate your input. Although I have been emotional over the situation in many posts, I'm back to once again making what I perceive to be the most rational decision. The company doesn't define my worth and I no longer feel slighted about the below-average salary. At the same time, I am actively working on automating as much as possible, which will be followed by an effort to lasso a second job. As it stands right now, I have zero in quitting my current role & immediately start a new job until I at the least take a +3 month work sabbatical or the standalone job pays 2x my current salary.
Completed Course
Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)
www.udemy.com
Got this course for free over two years ago. I think I found about it via one of those Twitter bots that tweet links to temporarily free Udemy Courses, so it felt good learning for free.
So to the unfamiliar, VBA is a programming language within Microsoft Office products that allow you to automate tasks. Excel is where I've seen it used the most but like you can click a button and Excel can automatically pull data from SQL Server, create a chart in Excel and then export + paste that chart in PowerPoint. It's a beast.
In terms of my skill level with VBA... I run a few reports that use it and I have to troubleshoot the code when something breaks, but since I'm not well versed, that usually involved me googling and trying a few things before I kick it higher up the chain to resolve.
After taking the course, the biggest realization is that getting tasks completed with "just enough knowledge" thanks to Google feels productive in the moment, but without that deeper understanding, that often-used but neglected skill eventually leads to inefficiencies/stress... It feels like a struggle to keep your head afloat maintaining a report that is slowly breaking. I'm sure some of you've had that sinking feeling when the solution on StackOverflow doesn't work on there are only two other relevant, but much-harder-to-read answers suggestions left
I was a little unsure at first about the course, but once again things are not nearly as intimidating once I
stopped thinking about it and instead,
started actually doing it. The biggest aha moment was realizing that the idea of Object-Oriented Programming is something I learned about in JavaScript. I was able to quickly find my footing logically when it comes to object methods/properties. Also dot notation was a quick learn thanks to JavaScript as well.
Next Steps
I am planning on taking the
Advanced SQL Server Course next, but I also realize that I have already learned enough to start automating tasks. I was thinking about doubling my daily study sessions, but now I am going to try and have at least once session daily geared towards automating work at my job. I kicked things off today by creating a few user-defined table functions that quickly return data and simple but repetitive questions. For example, it usually takes
8 lines of SQL code to answer questions around the size of a company, or the type of coverage they have, or when their contract is up, etc. but with the user-defined table functions, I can grab that data in 4
words.
I have a few more common queries to create this for before I move onto the next automation task. I will share the outline soon, but the general idea is that the work automation projects become more complex as I move down the list.