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.

365 Days

loading...