- 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.
Note: This course is priced for individual self-directed learning. Enterprise, organisation and government training programmes are delivered under separate accredited contracts and include additional compliance, reporting and quality assurance services. Prices for enterprise/government customers follow our formal rate card.
Promo Video
Section 1 - Introduction
Section 2 - Macros
Section 3 - VBA Editor
Section 4 - Variables and Procedures
-
14
1 - Introduction -
15
2 - Vraibales
-
16
3 - Variable Exercise
-
17
4 - What are Procedures
-
18
5 - What are Procedures - Part Two
-
19
6 - What are Procedures - Part Thre
-
20
7 - Message Boxes
-
21
8 - Input Box
-
22
9 - Input Box - Part Two
-
23
10 - Basic Navigation
-
24
12 - Cell Navigation
-
25
13 - Advanced Sheets
-
26
14 - Offset
Section 5- Loops and IF Statements
Section 6 - Error Handling
Section 7 - User Defined Functions
Section 8 - Assignments
Category:
Course details
Lectures
50
Level
Advanced
Google