CEMV01 - Comprehensive Excel Macro & VBA Course
v1
Version:
14 hours
Duration:
Overview
Excel macro is a set of instructions that can be used to automate tasks in Microsoft Excel. Macros can be created using Visual Basic for Applications (VBA), which is a programming language that is built into Excel. VBA is used to create macros and automate tasks in a variety of Microsoft Office applications, not just Excel. With VBA, you can create macros that can automate repetitive tasks, create custom functions, and interact with other Office applications like Word and PowerPoint.
Course Outline
Prerequisites
Advanced skills in Excel formulas mainly IF and VLOOKUP an advantage to understanding VBA easily. You may take a Comprehensive Microsoft Excel course to gain that skill.
Must have 2013 / 2016 / 2019 / 2021 / 365 Excel
Must use Windows to build VBA projects. For Mac users, use a virtual machine or a similar application to run Windows applications.
No prior knowledge of programming
Objective:
Learn how to read and write code of instructions in VBE
Utilize documentation and references
Build an actual automation project using VBAÂ
Â
Course Outline:
Module 1
Overview of the Project
What are Macro and VBA?
Macro Recorder And Fundamentals Of Elements
Absolute and Relative Macro
Creating Basic Procedures
Module 2
Features of Procedures
Absolute Vs Relative Objects
Range, Worksheet, and Workbook Objects
Module 3
Getting started with Events
Understanding Data Types
Declaration of Variables
Understanding Methods
Formula in VBA
Module 4
Conditions and Nested IF
With Statement
Do-Loop Statement
For-Next Statement
Module 5
Setting up the Project Part 1
Module 6
Setting up the Project Part 2
Module 7
Adding User forms And Controls in the Project
Instructor
Jaicon Ruedas
Jaicon Ruedas is Microsoft Certified Excel Expert and Microsoft Certified Data Analyst. He taught thousands of professionals, executives and individuals.