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
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.
Details
60545069
365 Days
English
System is currently experiencing issues and we are working on a solution. If you encounter an error, please come back shortly and try again.
