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