- Description
- Curriculum
Excel VBA (Visual Basic for Applications) is a hands-on course designed to help you master automation within Microsoft Excel. You’ll learn how to:
-
🧩 Write and edit VBA code to create macros
-
🔄 Automate repetitive tasks and data processes
-
📊 Build custom forms, buttons, and user-defined functions
-
💻 Integrate VBA with other Office applications
-
🛠️ Debug and optimize your code for real-world performance
Whether you’re a data analyst, finance professional, admin, or student, this course gives you the tools to streamline your workflows and boost your Excel skills to an advanced level. No prior coding experience required—step-by-step guidance included.
Promo Video
Section 1 - Introduction
Section 2 - Macros
Section 3 - VBA Editor
Section 4 - Variables and Procedures
-
141 - IntroductionVideo lesson
-
152 - VraibalesVideo lesson
-
163 - Variable ExerciseVideo lesson
-
174 - What are ProceduresVideo lesson
-
185 - What are Procedures - Part TwoVideo lesson
-
196 - What are Procedures - Part ThreVideo lesson
-
207 - Message BoxesVideo lesson
-
218 - Input BoxVideo lesson
-
229 - Input Box - Part TwoVideo lesson
-
2310 - Basic NavigationVideo lesson
-
2412 - Cell NavigationVideo lesson
-
2513 - Advanced SheetsVideo lesson
-
2614 - OffsetVideo lesson
Section 5- Loops and IF Statements
-
271 - IntroductionVideo lesson
-
282 - OperatorsVideo lesson
-
293 - Using VariablesVideo lesson
-
304 - What is AutomationVideo lesson
-
315 - For LoopVideo lesson
-
326 - Do LoopsVideo lesson
-
337 - IF StatementsVideo lesson
-
348 - IF Statements - Part TwoVideo lesson
-
359 - Select CaseVideo lesson
Section 6 - Error Handling
Section 7 - User Defined Functions
Section 8 - Assignments
-
381 - IntroductionVideo lesson
-
392 Exercise 1 - Record a MacroVideo lesson
-
403 - Exercise 2 - Duplicating DataVideo lesson
-
414 - Exercise 3 - Generate a ReportVideo lesson
-
425 - Generate a Report - Part TwoVideo lesson
-
436 - Exercise 4 - Inner and Outer LoopsVideo lesson
-
448 - Inner and Outer Loops - Part ThreeVideo lesson
-
459 - Inner and Outer Loops - Part FourVideo lesson
Related courses

EXCEL VBA
Category:
Course details
Lectures
50
Level
Advanced
Popular courses