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.
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
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
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.