Certification in VBA Macros in Financial Modelling

Introduction

Financial modelling is a key method to assess the financial health of a business. In today’s world, the business landscape undergoes rapid transformations, and organisations need to compete with one another to adapt to such changes and stay at the top. Adaptation requires strategic decision-making that depends on the constant assessment and evaluation of the business performance. To ensure consistent analysis of the business, it is crucial to automate the financial modelling process.

The requirements and ways of operating are unique to each business. Thus, automation solutions need to be customised to suit the needs of the specific business. Visual Basic Applications (VBA) macros can play a significant role in helping assess business performance in a timely manner and accelerate decision-making. These macros help businesses record an action effortlessly and replicate the same when required. This helps streamline the adaptation process and enables organisations to thrive in this highly competitive business landscape.

LearninGT is pleased to announce the launch of its certification called VBA Macros in Financial Modelling. This course is designed to equip participants with the best practices for employing VBA macros in financial modelling, allowing them to improve business processes and overall business health.

programmeme objectives

The programmeme will focus on:

Enabling participants to build templates for financial models by recording macros
Equipping participants with the best practices to use Excel macros for quick data processing and data analysis
Helping build user-defined functions in Excel and use events for the VBA procedures
Training participants in enhancing operational accuracy and reducing any failures in the models
Helping participants customise the automation process and expedite data analysis
Helping participants make data-driven decisions quickly using VBA macros

Who should attend

Professionals working in corporate finance, consulting, financial planning and financial markets
Professionals who use Excel for financial applications
Investment bankers
Equity researchers
Chartered accountants
Graduates with specialisation in MBA finance and commerce

programmeme deliverables

10 hours of learning content
Grant Thornton Bharat presentations as course materials
Two-way communication
Query resolution through an expert
Quiz and final assessment
LMS access for one year
Certificate of completion

programmeme coverage

Introduction to macros and basics
- What are macros?
- How to use macros?
- Visual basic editor and components
Macros recorder
- Recording a macro
- Rules related to macro names
Essentials of code writing
- Overview of VBA procedures
- Syntax of sub-procedures
- Variables and data types
- Methods to run sub-procedures
- Using Excel functions in VBA
- Debugging VBA code
Conditional statement
- If-Then-Else-If-Else statement
User-defined function (UDF)
- User-defined functions – Function procedure
Loops in VBA
- Loops
- For next loop
- Do until loop
- For each loop
Event-driven codes
- Overview of event-driven codes
- Auto code execution based on the change in a cell
Macro security and code protection
- Checking security settings
- Protecting the code
VBA - Security and protection using the developer tab

Fees

programmeme fees: INR 10,000 + taxes

Cancellation and refund policy

The refund policy in case of withdrawal of nomination would work as follows:-

A refund of 50% of the fee would be provided for cancellation requests received up to five working days before the training start date
Participants who cancel in less than five working days or do not show up on the training date are liable to pay the full course fee and would not be entitled to refunds

Cancellations must be made via emails only. However, desirous participants can be accommodated in future batches of the programmeme without paying an extra amount. It is requested that the willingness to attend any future programmeme should be communicated at the earliest convenience.