Learn Excel VBA Tutorial

Learn Excel VBA i.e. Programming Language with a practical approach
If you want to be a master at Excel VBA Programming language for Excel 2007, then our Excel VBA macros tutorials will make it easier for you to access it in applications such as Microsoft Office. Come create your own Macros and rule in excel.

  • Video Lessons = 129 (8 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Learn Excel VBA Tutorial online

What is VBA i.e. Visual Basic For Applications?

VBA stands for Visual Basic for Applications is the programming language of Microsoft Excel. Computers and technical devices have their own language to understand the data processing, just like us humans who need a language, i.e. a medium to talk to and converse. VBA is the language which Excel understands and talks in. VBA is known and can be used as the Programming language for other Office programs i.e. (Excel, Word, PowerPoint, Outlook, Access) as well. We always worry about learning new things thinking that it might be very difficult or we might get stuck somewhere. It is the same thing with learning a new language. 

Here’s the level of the course:

Intermediate Skills

Able to implement techniques at work
  • Using Loops
  • Optimizing Code Efficiency
  • Using Event tracking 
  • Creating Userforms
  • Recording Macro button

Advanced Skills

Ninja-level Skills
  • Creating User-defined functions
  • Mini Projects: Split, Protect-Unprotect, Automate Comment Extraction
  • Final Project: Corporate Travel planning Project (involves: advanced user forms and Email Automation)

Watch Free Lessons on Excel VBA

Excel VBA Macro basics

Excel VBA Tutorial Online Course

Excel VBA Macros Tutorial Online

Why Online Learners Trust Us?

You don’t have to pretend that you’re satisfied with our work. If our tutorials have helped you we are more than happy. Customer satisfaction is what we are looking for. But in case, if you’re not satisfied then contact us anytime within the next 30 days of your enrollment period. We will refund your money.


30 Days Money Back Guarantee

Full 30 Day Money Back Guarantee No Questions Asked

Course Completion Certificate By YodalearningCompletion Certificate

  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn

Learner testimonials

  • I would like to tell you that I am very impressed with your excel courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights

  • Dear Rishabh, I am a subscriber to Excel VBA course on your training site – Yoda Learning. And, I am amazed by your style of teaching and making complex subject of VBA very easy. I feel more connected with your courses as they are result oriented and I think that is mainly because of your CA and industry background.

    Rishikesh Joshi
  • Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed.

    Barbara Jones
    Financial proffesional

We’ve helped these COMPANIES

with exact strategies and techniques used in this course



Course Curriculum

Module 1: WARM UP – 10 MIN

Excel VBA ModuleWith this Module, you’ll learn the Beginner level of tricks required to make any Presentation. You’ll get a proper Guidance on how to select and play right with the Colors and Pictures in a Presentation.✔ Quick Tour for Beginners
✔ Slide Background (Color & Picture)
✔ Slide Header N Footer
✔ QAT and Alt Key tricks


Excel VBA Module 2

With this Module, you’ll learn what you gain if you run record your own Excel Macros. You even get to learn how to Record and Run Macros.

✔ Macros – Record & Run
✔ Macros – Viewing the code
✔ Macro-free vs. Macro-enabled Workbook
✔ Visual Basic Editor (VBE)
✔ Personal Macro WB
✔ Ways to Run a Macros


With this Module, you’ll learn the magic words you need to Google to get the VBA Code right. The technique that can be used to Customize the Macro Code.

  • Using Google to locate useful VBA codes – 1
  • Using VBE and Macro Recorder to customise Macro code
  • Using Google to locate useful VBA codes – 2


With this Module, you’ll learn about Objects and their Properties. Most of the programming languages today are Object-Based and these are mainly Object-Oriented Programming Languages. You’ll learn how these are used coupled with methods of Excel.

  • Objects, Properties, Values, Methods and Parameters 1
  • Objects, Properties, Values, Methods and Parameters 2


With this Module, you’ll learn that a workspace factory object can be a lot useful in creating new Workspace. Learn about the various editing methods to edit tools bars in Excel VBA.

  • Code Color & Activating Edit Toolbar w. Comments
  • Edit Toolbar – Indent, Bookmark
  • Code writing shortcuts incl. Intellisense
  • Testing the Code
  • Immediate Window 01


With this Module, you’ll learn How to use the Cell Property to select a Range. And that making use of Cells is actually useful when you wish to loop through ranges. You’ll learn about the different Range and Cell objects.

  • Range Selection – Method 1
  • Range Selection – Method 2 & 3
  • Advantage of Range Selection – Method 2 & 3
  • Range Selection (Rows & Columns) – Method 4
  • Assigning values to selected range of cells
  • Exercise 1 – Assigning values to selected range of cells
  • Exercise 2- Assigning values to selected range of cells
  • Multiple Range Selection – Method 5
  • Multiple Range Selection – Method 6
  • RangeSelectionWays – Others


With this Module, you’ll learn that while you record a cell could be made relative if there is a need to start Position or the absolute Address. Compares relative and absolute referencing while recording Excel VBA Macros. 

  • Offset – Basics
  • Using Relative Reference in Macros


Picture8 Excel VBA Module

With this Module, you’ll learn one of the best and common use object that is the Range object. You’ll learn about Navigation in between a Range of Cells.

  • Navigating between a Range of cells – Part 1
  • Navigating between a Range of cells – Part 2
  • Navigating between a Range of cells – Part 3
  • Exercise – Finding Last Row No.
  • Exercise – Finding Last Column No.
  • Exercise – Finding Next Row No.


With this Module, you’ll learn Variable Declaration. Variable Declaration helps the Macro to run Faster. It helps to use the memory effectively.

  • Variable Decl 01
  • Variable Decl 02
  • Pvt vs Public 01
  • Pvt vs Public 02
  • Option Explicit
  • Difference – DIM vs. SET

Module 10: LOOPS – 52 MINS

With this Module, you’ll learn about loops in VBA. Looping is known as one of the most Powerful Technique of Programming. 

  • “For…Next”
  • “If…Else…End If” nested within “For…Next”
  • “Do…While”
  • “Do…Until”
  • “For Each…Next”
  • “If…End If” nested within “For Each…Next”
  • Exercise – “Do While” and Loop Counter”
  • With…End With” – Example 1
  • “With…End With” – Example 2
  • “Select…Case” – Demonstration
  • “Select…Case” – Explanation


With this Module, you’ll learn The Technique to Speed up the Slow Excel VBA.  You’ll get the information to optimize VBA Code to speed up the running of Macros.

  • Speed up the code running – 1
  • Speed up the code running – 2
  • Speed up the code running – 3


With this Module, you’ll learn about tracking all the events in VBA. For example, if a user ever changes the selection. Also, tracking the Worksheet changes of event.in Excel VBA. 

  • Introduction
  • Events – Workbook_Open and Worksheet_Activate
  • Exercise 1 – Tracking Workbook Opens
  • Exercise 2 – Tracking Workbook Save
  • Event – Worksheet_BeforeDoubleClick
  • Event – Worksheet_Change
  • Event – Worksheet_Calculate
  • Pivot Table – Refresh – WorkSheetActivate

Module 13: INPUT BOX – 23 MINS

With this Module, you’ll learn to use the INPUT BOX function in Excel VBA to initiate the Users in putting their input.

• Introduction
• Input Box – 1
• Input Box – 2
• Input Box – 3
• Input Box – 4

Module 14: MSG BOX – 16 MINS

With this Module, you’ll learn about the MSG BOX which is a Dialog Box in Excel VBA. You’ll learn to use the MSG BOX to inform users about your program.

  • Introduction
  • MsgBox – 1
  • MsgBox – 2
  • MsgBox – 3
  • MsgBox – 4


With this Module, you’ll learn to create ActiveX Controls in VBA. It helps to Overview Forms and even in Form Control.

  • Form Controls vs ActiveX Controls
  • MouseMove Event w. Appln Statusbar


With this Module, you’ll learn to make your own Functions. These Functions are called User Defined Functions. These are the Customize Excel Functions. These Codes allow you to take code from VBA and Rewrite it.

  • UDF Intro 001
  • UDF Example 1 – Score Result with IF END IF
  • UDF Example 2 – CellComments
  • UDF Samples – Series A
  • UDF Samples – Series B

Module 17: USER FORMS – 74 MINS

With this Module, you’ll learn to create USER FORMS, this is helpful in making the User’s Data Entry Controllable. User Form helps the users to use data Easily.

  • Introduction
  • User Form – Basics
  • Exercise – Part 1 of 4
  • Exercise – Part 2 of 4
  • Exercise – Part 3 of 4
  • Exercise – Part 4 of 4
  • Option Button – 1
  • Option Button – 2
  • Multi-Page – Introduction
  • Multi-Page – 1
  • Multi-Page – 2
  • Multi-Page – 3
  • Check Box 001
  • Combo Box – Method 1
  • Combo Box – Method 2

Module 18: MIS PROJECTS – 40 MINS

With this Module, if you’re a motivated individual then you’ll learn various Advanced Excel VBA Techniques while taking VBA MIS Training.


With this Module, you’ll learn Combining WSheets, this is explained with Real Life Projects.

  • Combine WSheets

Start Learning Today

No Frills

[No Frills] Lifetime Access

129 Course Lessons
  • 129+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Lifetime access

[Premium] Lifetime Access

Lifetime Access + Lifetime Support + Certificate
  • 129+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

Office Training Bundle

Unlimited Learning [All YL Courses]
  • 129+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

Feel free to call us for any query related to courses. Our support team will resolve your issue.

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.


This Excel VBA Course is for you if...

✓ If you have doing repetitive tasks i.e. making reports, dashboards or slides and looking for ways to automate your task.

✓ If you’ve been dealing with reports from ERP system and apply the same formulas each time to generate the results.

✓ If you want Excel to talk on cross-platforms with other Microsoft applications

✓ If You want to use Excel for complicated & demanding tasks.

✓ If you want to create worksheet object, merge the data from various sheets and do heavy calculations.

✓ If you want to create your own small programs beneficial to perform tedious tasks for excel and want to be a master at programing language. With the help of Visual Basic for Application i.e. VBA, you can also create range object in Excel

This Excel VBA Course is not for you if...

✓ Your usage of Excel is pretty simple or you use it rarely [I love you guys, but this course will not help you]

✓ If you do not like formulas and hate calculations and coding.

✓ Your level of expertise for Excel is less than Basic (You are not aware of the terms of data cleaning technique, Vlookup, filter, sort and cell referencing)

✓ Anyone who wants an instant result and wants to join the course without taking any action in practicality and won’t practice the working files on regular basis.

✓ If you’re not that person who understands programming and neither you’re interested to learn about it.

✓ If you’re not loaded with data management tasks and do not need to perform complicated and heavy calculative tasks in your everyday life.

Frequently Ask Questions

How do I enroll for the Excel Visual basic for Applications tutorial?

Its simple to enroll for this Excel VBA tutorial. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
– Visa/Master Card credit card
– Through PayPal
– Don’t have a Credit Card? Click here

What do you get in this Excel VBA Tutorial?

  • An accelerated, Practical approached program to teach you
  • All VBA case studies related to videos and create simple macro
  • Access to all videos 24 x 7 – learn online from anywhere
  • Learning VBA will help you to understand Line of Code
  • A 30-day money back guarantee (we want you to be 100% satisfied)

Is There Certificate?

Yes, we offer course completion certificate after you successfully complete the training program.

What will I be able to do after completing this Excel tutorials?

✓ Won’t waste time in manipulating and repetitive formatting

✓ Use my excel file to send emails automatically (basically communicate with different tools)

✓ Make use of custom functions that can be run from things like a button on a spreadsheet, the Excel Ribbon

How Much time to complete this excel vba tutorial for beginners?

This is a fast-paced, lean program of about 10 hrs 22 mins with videos around the programming language from basics to advance and case study. Watch the preview video to get a flavor the program’s uniqueness and relevance.

What if I’m unhappy with my course? Do I get a refund?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.

What if I have doubt or question?

This course entitles you for a lifetime support. Just send us your questions from your registered email address to [email protected] and we will back to you as fast as we can.