Microsoft® Excel®: Introduction to VBA (Visual Basic for Applications) Macros Course
 
| 
Instructor-led (2 Days)
Upcoming Dates:
 September 30/October 1, 2025 (Online in virtual classroom or In-person)| November 19/20, 2025 (Online in virtual classroom or In-person)|  
Check for more dates >
Duration:
 2 days - 9 am - 4 pm (ET)
Microsoft Excel Versions:
 2016 | 2019 | 2021 | 365 (Windows)
Delivery Methods (Instructor-led):
 In-person (Live classroom) training or Online (Virtual classroom)
Course Fee:
 $495 CAD per person + HST (Online in virtual classroom), $545 CAD per person + HST (Bring your own device for in-person courses) or $595 CAD per person + HST (Avantix Learning provides device for in-person courses)*
Virtual Classroom:
 Virtual classroom courses are delivered online by a live instructor and run from 9 am to 4 pm (Eastern Time) with a 15 minute break in the morning and in the afternoon and a 1 hour break for lunch.
In-person (Live Classroom) Course Location:
 Our live classroom courses are offered in downtown Toronto at the Toronto Eaton Centre or at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some Avantix Learning courses may be held at an alternate downtown Toronto location). Location will be confirmed when you register.
Learning Path:
 Level 4
Prerequisite:
 
Microsoft Excel: Intermediate / Advanced
 or equivalent knowledge and skills.
Public scheduled courses are delivered as live instructor-led classroom training or virtual classroom training (as indicated). Bring your own device rates apply to live classroom courses. Some courses / formats may have a minimum enrollment requirement.
*Some courses and formats may be subject to a minimum enrollment requirement.
In this course, students will learn to automate Excel by writing VBA (Visual Basic for Applications) macros. Designed for the non-programmer, students will start by recording VBA macros usng the built-in macro recorder and then write and edit VBA code for sub procedures (macros). In the Visual Basic Editor, students will work with projects, insert modules, write procedures, and use variables and constants. If statements and looping will also be used in this course. Students will run macros using the Macros dialog box, buttons and keyboard shortcuts. A user-defined function will also be created to automate a calculation. Throughout the course, the instructor will include numerous tips, tricks and shortcuts.
Course topics
Overview of Macro Concepts
What is a macro?
Displaying the Developer tab in Excel
Creating macros using the Macro Recorder
Assigning a keyboard shortcut
Viewing a list of macros
Viewing the VBA code for a recorded macro
Absolute vs relative referencing
Limitations of recorded macros
Saving and Opening Files with Macros
Deciding where to save macros
Saving workbooks with macros
Opening workbooks with macros
Macro Security and Trust Centre Settings
Specifying macro security settings
Creating a trusted folder
Working in the VBE (Visual Basic Editor)
Overview of VBE menus and toolbars
Displaying different parts of the window
Working with the Project Explorer
Viewing the iVBA Code window
Setting properties
Displaying other windows
Returning to Excel
Getting Started Writing Code using VBA
Inserting a module
Basic VBA syntax logic
Creating sub procedures or macros
Naming sub procedures or macros
Controlling the display of code
Adding comments
Referencing objects
Using methods and properties
Getting help
Working with Modules
Different ways of Inserting new modules
Creating multiple sub procedures in a module
Renaming modules
Deleting modules
Saving a backup of modules
Running Macros
Using the Macros dialog to run macros
Running macros using keyboard shortcuts
Running macros from within the VBA window
Displaying buttons on the Quick Access Toolbar or the Ribbon to run macros
Running macros by creating buttons on a worksheet
Using Variables and Constants
Using constants and variables in VBA code
Types of variables including integer, long and string
Declaring variables
Benefits of declaring variables
Changing Scope
Procedure level scope, module level scope or public scope
Displaying Input Boxes and Message Boxes
Displaying messages
Using input boxes for entry
Using message boxes and input boxes with variables
Displaying different types of buttons
Using If Statements in VBA
Benefits of If … Then statements
Syntax for If … Then … Else statements
Using If statements with message boxes or input boxes
Using For … Next Loops
Using loops
Using For … Next loops
Ending a loop
Changing loop step values
Basic Debugging
Common errors and break mode
Using Reset
Commenting out problem lines of code
VIEW FULL COURSE OUTLINE >
Who will benefit
This course has been designed for Microsoft Excel users who have completed the 
Microsoft Excel: Intermediate / Advanced
 course or have comparable knowledge and skills.
Can I bring my own device?
Absolutely! If you choose to bring your own device, you will receive a reduced rate. Be sure to bring a power cord and a mouse is helpful.
What's included
Included in this course:
Comprehensive course manual (150+ pages)
Keyboard shortcuts quick reference
Sample and exercise files
Refreshments (for classes conducted in Avantix Learning classrooms)
Certificate of completion
Follow-up email support
Related Microsoft Excel courses
Other courses in this series include:
Microsoft Excel: Introduction
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: New and Essential Features and Functions in Excel 365
Microsoft Excel: Introduction to Power Query to Get and Transform Data
VIEW MORE COURSES >
About Avantix Learning courses
Avantix Learning offers live instructor-led classroom courses and virtual classroom courses allowing personal interaction between the students and the instructor. We specialize in small classes, typically ranging from 6 to 10 students to ensure an optimal student to instructor ratio.
Live classroom courses are offered in downtown Toronto at 18 King Street East, Suite 1400, Toronto, Ontario, Canada. Some courses may also be offered at an alternate downtown Toronto location.
Our top-notch instructors have years of experience in the business world and students are encouraged to ask questions during our courses. Avantix Learning senior instructors have 15 or more years of experience. A complete profile of the instructor leading a specific course is available on request.
Questions?
Have a question? Email us at 
info@avantixlearning.ca
.
You can also find information about all of our courses on our web site at 
www.avantixlearning.ca
.
Refunds/Cancellations
We understand that your plans may change. Check out our 
refund policy
 for information regarding refunds and transfers.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Information Source: Avantix Learning Inc. | eventbrite

Toronto

Colombia

Searching for information and tickets regarding Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto taking place in Toronto on Sep 30, 2025 (UTC-4)? Trip.com has you covered. Check the dates, itineraries, and other information about Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto: Tickets, Dates & Itineraries | Trip.com

Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto

Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Trip.com

null | Trip.com

Share your results and see what your friends think!

Recommended Products for Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto

Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto

Details

Vote

Are you interested in Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online?

Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online | Avantix Learning - Online in Virtual Classroom or in Toronto

Details

Vote

Are you interested in Microsoft Excel: Introduction to VBA Macros Course in Toronto or Online?

More contents about Toronto