5 Ways to Use VBA Macros for Excel in Your Job

In this video I share 5 different ways to use VBA Macros for Excel in our jobs.
We can use macros to automate both simple and complex Excel tasks, and save a TON of time with our job.

This includes everything from simple data related tasks like removing duplicates, creating formulas, and copy/pasting data. To more complex tasks like building pivot tables or updating 100's of Excel files with data.

In the video we look at several examples of macros in the following 5 topics:

- Data related tasks 0:30
- Workbook tasks 3:57
- Pivot Table tasks 5:23
- Userforms & Add-ins 6:51
- Process Automation 8:52

You can download the Excel file used in the video at the following link.

Please register for my free webinar on "The 7 Steps to Getting Started with Macros & VBA" to learn more about how to use macros to automate tasks, save time with your job and advance in your career.

Here is the link to register. It's FREE!
00:00 Introduction
00:25 5 Uses for VBA Macros
00:46 Data Related Tasks
04:01 Workbook Tasks

[emmaren]

I really like your tutorial webnars. Clear & logical. Very impressive. I have learned Pivot Table, VLookup, Xlooup, and etc etc. Now I start to learn Macro. My job become more and more effciency. Your tutorials are the NO1 choices.

[officetricks]

All the 5 are most useful in tips while working on vba. great video...

[lettysantos]

I wasnt lucky enough to be accepted on my online job because I dont know anything ahout VBA. Thanks John for the info. Love your voice.

[BOWENSblog]

Huh this looks like a cool hobby to work on in the future. To incorporate in the corporate world as a non-freelancer to be more versatile, communicate and be more considerate to others. I don't know much about VBA or programing but it's another area to grow for fun and improve career trajectory in the future decade

[Snowflake_Baiter]

Hi Jon, Firstly I have been watching your videos and I think you have a genuine gift for teaching and the videos are wonderful and executed perfectly. I am an average VBA programmer but have been out of touch these last few years due to a change in job role. I was wondering if you would consider doing one of your excellent production on reading from PDF files using "Reference libraries"

[violetchikanya]

Thank you for the tutorial, it is very educative

[markettrader]

Macro macro - god, I have to learn this for work but I cannot think of anything less interesting in the world.

[christophermatthews]

Hey John, I'm a fairly decent vba coder and been looking for ways to up my game to highly advanced. This was a GREAT video and I appreciate your time and effort in making it. I may consider signing up for you class depending on how it is set up.

[sf]

Great.. Thank you sir. Appreciate ur works very much

[rickkeev]

Jon excellent video thanks for sharing. What can I add to your code that will group the shapes? When it makes those thumbnails it creates 2 shapes and I'd like to combine them to 1 shape.

[Siva-DigitalEnglishEducation]

Hi John, I have registered for the webinar on 13th. Thank you sir for providing this good opportunities to learn ourselves.
I have a doubt like we have developed a macro in one workbook and closed it. So, now we have opened new work book how can we run that macro from closed work book in new work book.

[avbprogramminguser]

Good for VBA programming and VB6 programming

[kaaa]

thank you so much for the tutorial. I created a save button but when I click on it, I get this message. "Cannot run the macro… the macro may not be available in this workbook" I already, set the trust center setting to trusted location. Thanks

[MehediHasan-pvem]

Hi I'm new in excel.there are a lot of videos on excel but I can't understand from where I should start. please give a suggestion.

[DevilDog]

I have an excel file for work that I created that uses around 10, 000 "unique" equations. Each cells references other cells to compute a calculation.
Can I use VBA Macros?

[Faiz_Maik]

Hello Sir, Can you please teach me how to make coding for our sheets in excel according to data which is maintain. Please reply must

[flyfastmedia]

Hey Jon, I would like to buy even a recording of your course (the link says it's no longer offered). I need to do exactly what you described in #5 @8:55. I made a budget for a business with 25 offices by scratch. I need to update it weekly/monthly. Please help, haha, I've search everywhere. I can teach myself, just need recording.

[cammon]

Hi Jon. I've tried to download the above file but nothing is happening. Would you please send the file to me:

[bernardobeneitezbenet]

How did you make the "My Macros" tab?

[pastordonkoh]

At 7:00 I notice the excel assumed your gender