Excel VBA (Macro): 1 Hour Crash Course for Absolute Beginner
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)
- 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)
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
Who this course is for:
- Absolute beginners who wish to automate their mundane work tasks using Excel VBA/Macro
Being a back-office/operations office worker for around 10 years, I have learnt learn Excel VBA/Macros on my own to help out with my daily work tasks. With around 10 years of experience with Excel Macro/VBA, I have helped my company write countless automation scripts and accepted a number of freelance jobs on macro writing.