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
- June 24, 2026, 1:00 p.m. - 5:00 p.m.
- June 26, 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 a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
If available, course materials can be accessed 2 business days prior to the course and should be downloaded in advance.
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.