Looping and working with VBA change events in Excel (60545069) - Recorded webinar

This recorded webinar works through advanced techniques in the VBA language. Looping, creating IF statements and change events to manage information.    

Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals. 

Key topics:     

• Develop looping constructs – how to loop through a range of cells efficiently
• How to perform the same macro a specific number of times   
• Loop through sheets and manipulate and cleanse your data to save time   
• Change events to trigger a macro when a cell or group of cells change   
• Create IF statements in VBA to trigger an event

As part of this webinar you will  receive:

• Downloadable worksheets with practical tasks to embed the knowledge 
• A learning manual with step by step instructions 

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.

Course updated: 2020

• Develop looping constructs – how to loop through a range of cells efficiently, how to perform the same macro a specified number of times
• Loop through sheets and manipulate and cleanse your data to save time
• Change events to trigger a macro when a cell or group of cells change
• Create IF statements in VBA to trigger an event