And it all can be done within seconds.Īlmost anything that is repetitive and structured in nature can be automated to the point where you only have to click a few buttons to get it done. You could even set things up to save and email the report once you’re done. With a macro, you can connect Excel directly into your database, pull the data right into your spreadsheet, and format/summarize the data in the exact manner you need. Even if you’re great at using pivot tables and advance functions you still have to sink your very limited time and energy into “slicing-and-dicing” the data until it’s useful. You have a weekly report that you put together by downloading sales data from your CRM or accounting system, formatting it (such a pain), then summarizing that data into useful information. If you can save time it also means you have gained the skills to eliminate boring tasks altogether by automating them. I could’ve just lumped this together with the previous point, but I want to emphasize what “saving time” really means. Reason # 2: Eliminate Boring Tasks, for good!
With careful planning I was able to create a macro that took our billing data and converted it in the exact format required, in less than 15 minutes! This made it possible to: Talk about wanting to flush your head down a toilet! We’re talking tens of thousands of rows of data! This was a colossal undertaking that required 13 hours of uninterrupted focus to complete. Our billing data was not compatible with their format, so we had to manually make it compatible. Our company had an important vendor that required their bill sent to them in a specific format and file type.
That’s exactly what I was able to do a few years ago, and with very limited knowledge of VBA programming and macros. Imagine spending no more time in the office than you need to because you were able to build a tool in Excel that, for example, with a click of a single button formatted all those data files the exact way you needed them. The joy I get when I take a boring task from 3 hours to 20 minutes… Top 3 Reasons you should learn to write macros: It’s time to make a change and take back control of your career.
What do most people do when they see a tsunami of work approaching? They dig in their heels and work longer hours, later nights, and sacrifice their weekends in the name of “hard work” and “showing the boss they’re committed. You have too many episodes of Seinfeld you want to watch before Hulu takes them all down (kidding). Otherwise, strap in because I’m going to show you exactly why you need this skill on your resume ASAP. If you haven’t already make sure to check that out. I cover a lot of what macros are and what they can do for you in my previous post, VBA Quickstart: Zero to Awesome in 20 Minutes. It is the single best skill to master for automating your tasks and taking back control of your day.
BEGINNER EXCEL VBA TRICK FOR EMPLOYERS HOW TO
Learning how to write time-saving macros in Excel has become the key to reigniting millions of careers around the world. The good news is there’s a way you can gain more time and freedom to work on interesting projects by streamlining your work through automation, turning grueling hours into minutes, while showcasing your skills and gaining opportunities to earn BIG! Send it! I HATE spam and I promise not to send you any.
BEGINNER EXCEL VBA TRICK FOR EMPLOYERS FREE
I'd like to receive the free email course.