Identifier: 60545069

Duration:

Subscription Period: 365 Days

Language: English

Cost: GBP 33.00

 

Action

Add To Cart

Overview

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.

loading...