Learn how to automate repetitive tasks with the use of Visual Basic for Applications (VBA) in Microsoft Excel.
Overview
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.
Using practical exercise for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
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 method 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
As part of this webinar you will receive:
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step by step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Implement sheet referrals to avoid errors caused by sheet name changes
- Trap a changing range (dynamic range), and copy the moving range to a new location (using paste values, paste formatting, paste everything)
- Use SpecialCells method to isolate and manipulate information (delete, highlight or copy data)
- Use the find and replace with VBA to locate and change data
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.