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