VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS Excel, MS Outlook, and MS Access. VBA is a powerful tool that can significantly improve working efficiency and accuracy. Following the widely acclaimed VBA introductory webinar hosted in December 2021, CCPAA-ON now brings the introduction to Task Automation for people interested in VBA but with limited programming knowledge. The workshop prepares you for the world of VBA programming by:

• Introduce various data types, syntax and common debugging methodology.
• Easy and Replicable Excel VBA codes that you can directly use for your work
• Write triggers, loops, function and if statements to enhance your productivity.
• Interact with multiple spreadsheets and extract data to a central location
• How to edit excel and generate pdf bulk
• How to use VBA to send emails and attached files automatically

  Featured Speaker Fredrick Manager, TD Wealth Operations Fredrick is a manager at TD Wealth Operations, leading process enhancement projects using VBA, JavaScript, and HTML that empower TD Bank to be The Better Bank and deliver exceptional experiences to clients across Canada. In his previous roles as a data scientist in an asset management firm, he developed a mindset to explore the practical use of data with programming languages such as VBA and Python. As a hobby, Fredrick develops a python trading algorithm that calculates the probability and magnitude of return of over 3000 assets on his watchlist.