Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
The ability to get that extra power out of Excel and simplify everyday tasks or develop spreadsheets with user interfaces, often depends on knowing small, quick macro routines in VBA. This workshop will cover a range of fundamentals and some of the most-used routines and techniques in Excel VBA. Participants will work hands-on with the instructor on examples using supplied data and templates.
Topics Include:
- Introduction to VBA - VBA Fundamentals
- Language Basics - Understanding Objects, Collections, Properties, Methods and Events
- Recording Macros - Understanding the Difference Between Recorded Code and Manual Code
- Manually Adding Functionality by Manipulating Recorded Code
- Debugging and Fault Finding - Common Errors and How to Identify Them
- Prompt for User Input - Understanding Variables, Creating Message and Input Boxes
- Initiating Macros - Initiating Macros through Command Boxes and Events
- Conditional Statements - using IF Statements to Execute Code
- Looping Code - Introducing the Concept of Code that Runs until a Condition is Met
- Taking Macros to the Next Level - Combining Various Concepts Applied to Various Scenarios
- Practical Examples - the Workshop Ends with Significant Time Spent on Real-Life Examples Writing from Scratch
Schedule
- November 12, 2024, 6:00 p.m. - 8:30 p.m.
- November 13, 2024, 6:00 p.m. - 8:30 p.m.
- November 14, 2024, 6:00 p.m. - 8:30 p.m.
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.
Electronic material can be accessed one week 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 a Software Developer and Data Scientist who operates his own company, having worked with over 100 clients in the retail and financial services industries. He has helped organizations improve their labour scheduling, inventory replenishment, markdowns and pricing. He develops data models, reporting, algorithms and solutions for any organization that wants to use data to improve decision making.