RIP: MY EXCEL VBA CAREER (2008-2024)
“If the ladder is not leaning against the right wall, every step we take gets us to the wrong place faster.” I love this quote from Stephen R. Covey which, I think, captures so much of what’s important about your career – and life in general!
FREE EXCEL COURSE: 30 DAY EXCEL ANALYST PLAYLIST
But, let’s quickly apply it to your Excel learning. There’s so much stuff to learn in Excel these days – formulae, Power Query, pivot tables … and perhaps VBA? You couldn’t possibly learn it all (personally my ability across just the above areas is ‘uneven’, to say the least!) To ignore this question is to waste your valuable time and resources. Is YOUR ladder learning up against the right wall, and how would you even know?!
WATCH THE VIDEO HERE
So, if you’re a manager putting together a team, a mid-career professional looking to ‘skill up’, or a student embarking on an analytical career, what Excel-related tools should you actually learn?
In this video, I share the exact Excel and Excel-related tools I’m using in 2024 to deliver value for real-world customers, from ‘one-person-band’ type setups to household name global corporations. I show you what managers are trying to do in Excel, how to identify different applications of Excel and, crucially, how to select the best tool for your specific situation.
EXCEL POWER QUERY FOR BEGINNERS
There’s no point learning more Excel formulae if you’re looking to automate a process. As I write, I note a big creator has just released a video about a new formula with a claim it will 'change everything'. Will it? I would suggest you can only achieve fundamental change by properly understanding ... the fundamentals. Yes, you might not need MORE Excel formulae!
I also discuss the role of Excel VBA in my day-to-day analytical work. I’ve invested huge amounts of time in VBA over the years – learning, content creation and, of course, consulting to organisations. But, is VBA now dead? And what place should it occupy in your analytical toolkit – if it should it be there at all?
You should leave this video with a strong sense of where your personal emphasis should be – and, hopefully some motivation to move more effectively towards your Excel success! I include links to beginner videos to help you ‘balance out’ your toolkit, should you sense it isn’t configured optimally for what you are trying to do. I know mine wasn’t at the start of this year …
I’d love to hear what you make of the video – let me know in the YouTube comments! I’ll get back to you there.
GET OUR VIDEOS STRAIGHT TO YOUR INBOX WITH A FREE BLOG MEMBERSHIP