This course targets learners who require knowledge of Excel’s underlying programming language, with a view to extending the functionality of macros, as well as creating functions and automating complex tasks.
What Can You Expect?
This course targets learners who require knowledge of Excel’s underlying programming language, with a view to extending the functionality of macros, as well as creating functions and automating complex tasks.
What Is Required From You?
To ensure success, you should have successfully completed all Excel levels or possess the equivalent knowledge.
3 Day Course Content
Day 1
Understand How VB Talks To Excel
Understand Automation
Start Microsoft Excel Macros
Record, Run and Edit A Macro
Run A Macro From Visual Basic
Step Through A Macro
Understand the VB Environment
The Code Window
The Project Explorer
The Properties Window
The Immediate Window
The Object Browser
Write Visual Basic Statements
Make Long Statements Easier To Read
Create, Declare and Assign Variables
Use Syntax Help In Visual Basic
Exit Visual Basic Transpose
Skip Blanks
Link
Day 2
Work With Excel Objects in Visual Basic
Collections, Properties, Methods And Events
Understand And Use Workbooks And Worksheets
Understand And Define Ranges
Manipulate Drawing Objects
Manipulate Charts
Use Values And Formulas In Ranges
Understand And Use Relative And Absolute
Enhancing Recorded Selection
Simplifying Selection Pairs And Groups
Manipulate PivotTables
Day 3
Control Visual Basic
Use Conditional Statements
If… Then… Else
Case Statements
Create Loops
For Each Loops
For Loops
Do Loops
Extend Excel and Visual Basic
Input Boxes
Message Boxes
Work With Functions
Using Excel Functions In Visual Basic
Create Custom Functions
Add Function Arguments
Explore Volatile Functions
Developer
Handle Errors: Ignore, Check For And Trapping Errors
Launch Macros With Events
Active X Controls
Create Custom Forms
Launch A Form
Animate Objects
Package The Application
Keybase Pretoria is an accredited training centre based in Moreleta Park, Pretoria East. We specialize in all Microsoft courses from Basic to Advanced as well as soft skill courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy