Learn how to automate repetitive tasks with the use of Visual Basic for Applications (VBA) in Microsoft Excel. Move away from the macro recorder with some simple lines of code to automate your spreadsheets.

This recorded webinar will focus on introductory VBA within Microsoft Excel.

Key topics:

  •  Visual Basic for Applications (VBA) – some common terms
  • Copy raw data from one place to another using a recorder – examining the code and doing the same task efficiently
  • Referring to ranges, sheets in VBA – the best way to avoid errors
  • What is a dynamic range and how do you trap one consistently?
  • Using SpecialCells in VBA – how it can save wasted code
  • Finding data in a moving feast of information
  • Replacing data on a sheet without the use of looping

Learning objectives

  • Referring to sheets to avoid errors in a change of sheet name
  • Trapping a changing range (dynamic range), copy this moving range to a new location (paste values, paste formatting, paste everything)
  • Using SpecialCells to isolate and manipulate like information (delete, highlight or copy data)
  • Using find and replace with VBA to locate and change data
  • 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...