Subscribe to The Knowledge Academy’s top courses
Get this course, plus 11,000+ of our top-rated courses, with Personal Plan
Microsoft Excel VBA and Macro Training
Office ApplicationsUnlock the power of automation and customisation to streamline your spreadsheet tasks.
See Related CourseWhat you'll learn
-
Understand the concept of Excel macros and VBA programming.
-
Familiarise yourself with the VBA Editor and Excel Object Model.
-
Understand essential Excel objects like Application, Workbook, and Range.
-
Master fundamental programming constructs like loops and conditional statements in VBA.
-
Learn to design and customise user forms in Excel.
-
Explore various form controls and their functionalities.
-
Gain proficiency in creating and managing procedures in VBA.
-
Understand the concept of variables and their usage in VBA.
This course includes
tv8h On-demand Video
10 sections
30 Activities
10
20
Unlock full course by purchasing this course today! Dive deeper into the content and elevate your learning experience.
Recorded Macros
11m 33s
Crossword Challenge: Mind Twisters Edition
0m 0s
Accordion Guide: Demystifying Excel VBA
0m 0s
Understanding Excel VBA
20m 49s
Mastering VBA: The Ultimate Quiz Challenge
0m 0s
Demystifying VBA: A Step-by-Step Excel Programming Guide
0m 0s
Starting with Excel VBA
10m 25s
Embark on Excel VBA: Fill in the Blanks Adventure
0m 0s
Search and Find: Excel Object Edition
0m 0s
Using Excel Objects
13m 32s
Excel Object Mythbusters: True or False Challenge
0m 0s
Excel Objects Unveiled: Sorting Fact from Fiction
0m 0s
Programming Techniques
11m 42s
Select the Right Path - Single-Choice Challenge
0m 0s
Navigating Collections: The For Each Loop Unveiled in VBA
0m 0s
Creating Custom Forms
9m 24s
FormFusion: Drag & Drop Mastery with Custom Excel Controls
0m 0s
Mind Unleashed: Memory Mastery Challenge
0m 0s
Procedures
14m 44s
Excel Form Wizard Flashcards: Mastering Custom Forms and Controls
0m 0s
Procedure Puzzle: Visualizing VBA Mastery
0m 0s
Using Variables
15m 56s
Excel Form Challenge: Mastering Complex Fill in the Blanks
0m 0s
Excel VBA Variables Deep Dive: Unraveling the Code Tapestry
0m 0s
Functions in VBA
6m 34s
Excel VBA Vocabulary Hunt: Mark the Word Challenge
0m 0s
The Ultimate Excel VBA Course: A Comprehensive Toolkit
0m 0s
Error Handling
13m 20s
Excel VBA Wizardry: The Ultimate Quiz Challenge
0m 0s
Dialog Cards Delight: Enhancing Excel VBA Conversations
0m 0s
Unlock badges by purchasing this course today! Dive deeper into the content and elevate your learning experience.
Unlock certificates by purchasing this course today! Dive deeper into the content and elevate your learning experience.
FAQs
Review Summary