Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Many professionals spend valuable time performing repetitive tasks manually in Excel and learning VBA code can help automate those processes and dramatically improve efficiency. This course introduces the powerful, often overlooked capabilities of Excel VBA, so you can streamline your workflow and unlock more from the tools you already use.
Topics Include:
- The Excel VBA Environment
- Macros
- Variables and Expressions
- Branching Code
- Looping Code
- VBA Functions and Excel Functions
- Sub and Function Procedures
Schedule
- August 19, 2026, 1:00 p.m. - 5:00 p.m.
- August 21, 2026, 1:00 p.m. - 5:00 p.m.
Key Takeaways
Upon completion of this course, learners will be able to:
- Automate manual tasks in Excel.
- Build spreadsheet tools for others.
- Reduce spreadsheet errors.
- Learn new features in Excel.
- Have a competitive advantage in the workforce.
Who Will Benefit
This course is ideal for professionals who rely on Excel and want to reduce the time spent on repetitive, manual tasks.
Prerequisite(s)
- Basic familiarity with Microsoft Excel.
- Learners will need a Windows based laptop with Microsoft Excel to participate in the examples.
How to Access the Course
This course is delivered as a live webinar. To receive verifiable CPD hours, you must attend the session live. We recommend joining at least 5 minutes before the scheduled start time. For the best interactive experience, please use a computer equipped with a camera and microphone.
A reminder email with the Zoom link and course details will be sent two business days before the session. If you do not receive it, please check your spam or junk folder.
The same information, including any available materials, will also be posted in advance on our Blackboard LMS.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Scott Cuthbertson is an experienced Data Analyst, Data Scientist, Software Developer and Coding Workshop Teacher. He analyzes data, builds applications and leads workshops to show business people how they can automate their workflows. He has taught coding skills at CPA Ontario for over 10 years.