Excel VBA (Macro): 1 Hour Crash Course for Absolute Beginner

Learn only the essentials of macro writing, recording and concepts to quickly automate your daily tasks

This course is suited for students who wish to quickly learn how to write their own Excel Macro for their daily work tasks. If you have zero knowledge on Excel Macro/VBA or only knows how to record macro, this course takes a step further to teach you how to do write your own piece of code to help you with your mundane/repetitive tasks.

What you’ll learn

  • Macro Recording and editing it to suit your needs.
  • Basic building blocks of Excel Macro.
  • Write more complex functions by sourcing online content.
  • Fix Excel Macro errors (Debugging).

Course Content

  • Introduction –> 2 lectures • 2min.
  • Macro Recording, VBA Building Blocks and Debugging –> 16 lectures • 56min.

Auto Draft

Requirements

  • Basic Knowledge on Microsoft Excel.
  • Little/No programming knowledge needed. This course teaches you the essential building blocks needed..

This course is suited for students who wish to quickly learn how to write their own Excel Macro for their daily work tasks. If you have zero knowledge on Excel Macro/VBA or only knows how to record macro, this course takes a step further to teach you how to do write your own piece of code to help you with your mundane/repetitive tasks.

 

What is the difference between this course and the rest?

What set this course apart from the rest is that it is designed to be compact and right to the point. The main goal of this course is to teach you how to write Excel VBA code to help you with your own tasks in the soonest possible time. The topics covered are carefully picked so that you will only learn the essentials that are needed for the purpose of administrative/back-end tasks automation. This course does not aim to teach you to be a professional VBA writer who conforms to the best practices.

 

What you will learn:

  • Macro Recording and editing it to suit your needs
  • Write essential building blocks of Excel VBA
  • Write more complex functions by sourcing online content
  • Learn how to fix Excel Macro errors (Debugging)

Note

  • The course is taught using Microsoft Excel 2019 but the technique works with any version of Excel.
  • No support for students who are using Excel in Mac as I do not use Excel in Mac
Get Tutorial