Overview
This course on Excel VBA Advanced Tutorial aims to teach users how to automate repetitive processes and build tools in Excel using Visual Basic for Applications (VBA). By covering foundational VBA concepts such as loops, conditional statements, and complex functions, learners will be able to create their own macros from scratch. The course is designed for Business Analysts, Data Scientists, and individuals interested in expanding their Excel skills through automation and customization.
Syllabus
Start
Variables
Variable Rules
For Next Loop Basics
For Next Loop Doubled
For Next Loop Triple
For Each Loop
Exit For Statement
Do While Loop
Do While Not Empty Loop
Do Until Loop
Do Loop UNTIL
Count and Offset
End, Address, Call Statement
Practice
Using the FIND Tool in a Macro
Message Boxes
Input Boxes
Code Continuation Character and vbCrLf Constant
If Then, ElseIF, and Else
Select Case
Multiple Variables
Practice
Taught by
Learnit Training