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