Learn Excel VBA for Free Today

Learn Excel VBA with this free preview video. The video starts with the basics of recording a useful Excel macro. You will then start writing your first VBA procedure and learn the fundamentals of Excel VBA.

In the full course you will go from beginner to advanced level. You will learn about loops, interacting with the Excel user, working with files and directories, arrays and much more.

This free video course covers the basic skills of Excel VBA. Listed below are the topics covered and when so that you can skip to the parts of interest.

Recording Macros
1 - Recording a Macro - 00:04:33
2 - Saving a Macro Enabled File - 00:16:09
3 - Assigning a Macro to a Toolbar Button - 00:21:46
4 - Customising the Ribbon - 00:28:23
5 - Adding your Macro Button to the Worksheet - 00:35:44
6 - Editing the Macro Code - 00:42:16
7 - Using Relative References when Recording Macros - 00:50:05

Getting Started with VBA
8 - Introducing the Visual Basic Editor - 01:05:20
9 - Writing your First Macro - 01:14:02
10 - Cleaning Recorded Code - 01:37:16
11 - Working with Method Arguments - 01:48:27
12 - Referring to Cells, Sheets and Workbooks - 01:57:15
13 - Errors in VBA - 02:27:10

Working with Variables
14 - Using Variables - 02:35:39
15 - The Role of Option Explicit - 02:53:06
16 - Variable Scope - 03:03:36
17 - Using Object Variables - 03:12:47

In the full course you will have the downloadable files to work with and an instructor online to answer your questions.

Connect with us!

[CarlosMoreno-vwir]

Hi Im from Monterrey, Mexico, and I just wanted to thank you from the bottom of my heart.
for your kindness to share your knowledge …

[iykekanu]

I admire your selflessness and zeal to impact knowledge.

[apsellynch]

OMG OMG OMG.... didn't know this exist... love it 😍😍😍😍

[colinhuntley]

dear allan, i could watch (and listen) to your videos all day. they are highly informative as well as enterrtaining: at the moment i am enjoying your udemy course "formulas made easy" you are mind of priceless information (but i only paid euros 10, 00 for so much knowledge..
thanks a million, and i hope that you keep up the good work!

[Tanushree]

Thank you sooo much for the tutorial are a real saviour ..thank you once again..

[sarirgecol]

Thank very much, so amazing and informative

[atiqaraj]

Hi
i need to enroll in Excel VBA full course
Please let me know what i have to do

[ganesh]

Is this full course after watch full video can I get job in VBA