• Post category:StudyBullet-16
  • Reading time:4 mins read


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

What you will 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)

Description

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.


Get Instant Notification of New Courses on our Telegram channel.


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
English
language

Content

Introduction

Introduction
Developer Tab

Macro Recording, VBA Building Blocks and Debugging

Introduction to Developer Tab Buttons
Recording Macro
Recording Macro Quiz
Saving Macro Workbook
Creating Buttons to Run Macro
Creating Buttons to Run Macro Quiz
Step Into
Variables
Variables Quiz
“For” Statement
“For” Statement Quiz
“If”, “ElseIf” and “Else” Statements
“AND” vs “OR” Operator
CountA Function
“Do While” Statement
Using Macro Recording To Help With Macro Writing (Part 1)
Using Macro Recording To Help With Macro Writing (Part 2)
Sourcing Online Content To Help with Macro Writing (Part 1)
Sourcing Online Content To Help with Macro Writing (Part 2)
How to Fix Macro Errors (Debugging)