We have noted that many people are not as adept at using the software we have placed at their finger tips as we would like to think. As a result, we have found that one of the significant losses in the front office is time wasted that could easily be done by the software. Unfortunately, we simply don’t know how to do it.
The next time you find yourself entering even more data and formatting spreadsheets and reports, consider teaching yourself some VBA over the next few weeks to see how much you can do to help yourself by putting your software to work!
Awesome. I like to see encouragement for people to learn Excel from blogs that are not Excel blogs (i.e. normal people). Also, I’ve been studying the Toyota Production System, so seeing an Excel post on a lean blog is like worlds colliding for me.
I like the simplicity of the message. It doesn’t say “go be an expert” or “go start a VBA blog”. It simply suggests that you teach yourself some VBA over the next couple of weeks. How much VBA can you learn in a couple of weeks? In my opinion, it doesn’t matter. I’d say it’s quite likely that you’d learn something that significantly improves the quality or efficiency of your work. But even if you forget what you learn, there is still value.
When you’re ready, I recommend Excel VBA Programming for Dummies. I’ve read it several times (because I tech edited it) and I can say that is a great book for beginning VBA programmers. It reminds me of my freshman Calculus professor. She could make the most foreign topics seems easy and natural. The article mentions Microsoft Office Excel 2007 Visual Basic for Applications: Step by Step, which I haven’t read. I have read other ‘step-by-step’ titles and I’ve generally liked them.
I officially dub this week “Recruit a new VBA programmer” week.