This recorded webinar works through advanced techniques in the VBA language. Looping, creating IF statements and change events to manage information.
Overview
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
Objectives
- 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
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.