This course is designed to take the accountant or analyst to the next level as the world of VBA opens up to streamline repetitive report production. It will cover using VBA effectively to import source data, export output reports, consolidate financial data and create interactive dashboard sensitivities. The course will focus closely on VBA best practice and will be about creating well written, easy to read code, which is seamless to manipulate and maintain.
You will first learn what makes up VBA best practice and how to refer to ranges and worksheets so changing sheet names will not affect the smooth operation of processes. You will create consolidated and export procedures which will save hours or days in the production of reports. The practicalities of creating your very own custom function will be explored and you will generate your own custom function which will be used as the sensitivity for a dashboard report. The vagaries of looping with VBA will be explained and simplified as the two most important looping techniques are incorporated into practical applications.
Click on the image below for Marcus Small's biography.
This workshop is designed specifically for finance and accounting professionals who use Excel in their day to day roles.
Participants will gain the maximum benefit from this course if they are already competent spreadsheets users. The course is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions.
Please bring a USB.
Please note enrolments close 2 working days prior to the workshop date.
Looking for a customised learning solution for your organisation or team? Contact us today to discuss in-house learning options.