Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills

person icon Sihle Mhlanga

Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills

Beginner's Guide to Excel VBA

updated on icon Updated on Nov, 2023

language icon Language - English

person icon Sihle Mhlanga

architecture icon Excel VBA,Office Productivity

Lectures -60

Resources -5

Duration -3.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 8,500+ top Tutorials Point courses anytime, anywhere.

Course Description

Microsoft Excel VBA Fundamentals course is designed to teach relevant basic coding skills for VBA programming. It is for those who aspire to become a VBA programmer and don’t know where to start. It is also suitable for those who automate their spreadsheets by recording macros but seek to learn how to write the code themselves.

What should you expect in this course?

  • This course is entitled: Learn basic coding skills, it is NOT entitled Learn VBA basics

    • Therefore, we are focusing on the skill of writing a VBA code that is clean, maintainable, and easy to understand.

    • This is what you may call pre-basics or basics that are really basic; something you need to learn before you dive into Excel VBA concepts.

    • Your journey in your VBA career will start by learning:

      • What is VBA?

      • What are the tools used by a VBA programmer?

      • How to design an object, because before you start to learn how to write a VBA code, you need to understand what an object is. Otherwise, you will not understand the language at all.

      • After that, I will teach you how to send system commands that will manipulate the behaviour of the object you just created.

      • It is a free short course, but that will be enough to get you started.

    • What you will learn here is always a missing key to those who are struggling to understand VBA concepts, or to those who think they have understood the concepts, but when faced with a real-world project they get stuck and wonder why.

  • Almost every Excel VBA programmer did not start here,

    • they started by solving one problem and they got excited

    • and moved on to the next problem and another and their enthusiasm was amplified because programming is fun.

    • However, when they were tasked to build a project, programming became a very stressful thing because a project comes with plenty of related but different problems. Therefore, projects need someone who really knows what he or she is doing.

  • Now, before you start solving Excel VBA problems,

    • you need to understand that VBA is a language, and like all languages, it can be learned.

      • So, you need to understand what Excel VBA is about

    • If it is a language,

      • you must understand who or what are you talking to

      • You must also learn how to ask and get the information you are looking for, tell and be understood.

      • That’s what communication or language is all about; relaying information “to and from”.

    • In other words, you must learn how to structure a VBA code that can send clear commands to the system so that the system can in turn execute those commands without fail.

      • IMPORTANT: It is easier to learn the technique of writing computer commands if you are doing it without being clouded by complex VBA concepts that are deemed basic.

        • This is what this course intends to achieve, putting you on the right path.

        • The good thing is that this course is practical, which means, you learn and test your learning with what you are taking part in building.

  • This is Part 1 of the Beginner's Guide to Excel VBA series. After this course, you can go ahead and study VBA basic concepts whether with me (in Part 2) or somewhere else and everything will be clear because you now possess the most important thing, a clear understanding of VBA coding.

  • So, if you are looking for where to start learning VBA, this is the right place; it is a beginner’s guide.

Thank you


What will you learn in this course:

  • VBA (Visual Basic for Applications) programming language
  • Learn how to use the VB code editor
  • Get a general knowledge about the event procedures
  • Get a profound knowledge about the Initialize Event
  • Get a full understanding of Sub procedures
  • Learn how to write a clean and easy-to-maintain code
  • Separation of concerns
  • Understand the master-slave approach
  • Learn how to debug the code
  • Learn how to manipulate objects using the code
  • Learn how and when to use a With…End With-statement


What are the prerequisites for this course?

  • Basic understanding of Microsoft Excel
  • Zero knowledge of VBA
  • You must be using Microsoft Excel 2010 to 365
Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills


Check out the detailed breakdown of what’s inside the course

Course Overview
3 Lectures
  • play icon About This Course 03:33 03:33
  • play icon What's the best approach to learning the VBA language? 05:55 05:55
  • play icon What's Covered in this course? 04:00 04:00
4 Lectures
Source files
5 Lectures
Setting up the Developer Environment
9 Lectures
Designing the Date Picker
8 Lectures
VBA Coding
9 Lectures
Working with Constants
7 Lectures
Looping Through a Range of Objects
8 Lectures
Nested Loops
7 Lectures

Instructor Details

Sihle Mhlanga

Sihle Mhlanga

My name is Sihle Mhlanga and I’m an Accountant with a passion for Microsoft Excel.

I worked for companies with complex business structures. Over the years I have learnt how to adapt and conform to the challenges these businesses are facing by designing advanced Excel tools that don’t only simplify my work, but also work or do the job for me.

Recently I decided to build courses based on the real-world applications so that I can share my knowledge and help you stand out at work or acquire knowledge that will help you build tools that can simplify your business.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us