Top Video Tutorials for Creating Macros

Our earlier post here listed top websites to learn the VBA language for Excel. So now it’s time for the top video tutorials to get to grips with the macro features of Excel further…

To start off, this video gives a good introduction on how to start recording a macro

Next, Hun Kim gives a good basic introduction to working with macros:

‘Excel is Hell’ tries to alleviate the more ‘hellish’ Excel features by creating this helpful list of 35 short videos on tips and tricks to work with macros. https://www.youtube.com/playlist?list=PL5CEC03D7625A0D6E Useful when you are having problems and looking for a solution as the tips answer commonly asked questions e.g. ‘using the range property’ or ‘making dynamic cell references’

http://www.mrexcel.com/excel_video_training_vba.html Here you can find the directory of ‘VBA for macros’ videos from the well known Excel guru Mr. Excel

Xtreme Excel offers 17 videos here on creating macros. https://www.youtube.com/playlist?list=PL1R_HJw0CDYLYX_dcNxN4V_FlMeMGzeDW Includes an excellent 3 minute short intro to macros…as we’ve all been wondering what they actually are?!

VBA4Excel offers 4 beginner and 4 intermediate VBA videos https://www.youtube.com/user/VBA4Excel/videos

http://www.teachexcel.com/free-excel-macros/ Teach Excel offers many resources here but scroll down for the formatting macros section.

And finally Chandoo offers plenty of tutorials on VBA macros here for all abilities http://chandoo.org/wp/excel-vba/videos/

As always, there are courses you can pay for online to become Excel savvy, this one is only at $49 and dedicated to the ever troublesome macro ordeal.  http://spreadsheetsuperstar.com/excel-macro-training-course-online/

You can also view plenty here at lynda.com but you have to become a member to view all thevideos http://www.lynda.com/Excel-2010-tutorials/macros-in-depth/74463-2.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s