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.