John Tennent draws back the curtain and shows you how to get started with this powerful Excel tool.
Visual Basic for Applications (VBA) is the hidden language of Excel – it can automate and innovate in ways that traditional formulas can’t. But the language can be hard to get used to and is hidden – so join John Tennent as he draws back the curtain and shows you how to get started with this powerful Excel tool.
- The advantages and disadvantages of using Macros and Visual Basic for Applications (VBA) as well as some practical operational implications within an organisation.
- Demonstrating how to create Macros to automate repetitive tasks for which a limited knowledge of Visual Basic is required.
- Writing new Functions to speed up coding when building Worksheets
- Showing how to use Active X controls to create additional functionality.
- Developing Loops to repeat actions
- Creating Userforms to build highly controlled user interfaces
First broadcast on 22 November 2021
Webinar resources
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
