Training Courses
Course Categories

  • Home

  • Powerful Financial Modelling using VBA Macros

Powerful Financial Modelling using VBA Macros

Sydney

$3,575.00

Training Course ID: (CFG)-20020

Overview: In an increasingly complex and fast paced transactional environment the importance of accurate, efficient and powerful financial forecast models is paramount. Microsoft Excel Macros written in Visual Basic for Applications (VBA) has become an important feature in today's financial forecast models as it provides financial analysts with an efficient way to solve advanced numerical problems. If not used appropriately however, VBA can cause more problems than it solves!



Powerful Financial Modelling using VBA Macros, will take you through the most frequently used financial applications of VBA with a focus on financial forecast modelling. The VBA environment is thoroughly investigated and the level is gradually increased through numerous hands-on practical examples. There is a strong focus on transparency and efficient coding which minimises the risk of error or your financial model being perceived as a ‘black box’ by other users and stakeholders.









Training Course Details

Duration
2 days
TypePublic / Open
Provider

Corality Financial Group

CPD0
Venue

Level 8, 200 George Street Sydney

VersionAdvanced

Outlines

Training Course Outlines:

• Introduction to the VBA environment
• Core VBA skills and how it compares to other programming languages
• Reading and debugging VBA code to eliminate any errors even before they occur
• The building blocks of VBA coding - understanding variables and various loops
• Applying VBA macros to your financial models in a professional and efficient manner
• Create your own special Excel functions that you can use within your Excel formulae
• Make your financial model more user friendly to various users of the model
• Advanced Applications of VBA - learn things you never knew existed within Excel




Outcomes

Training Course Outcomes:

• Solve complex modelling challenges you didn’t think possible in Excel
• Save hours of your day by automating repetitive tasks
• Impress stakeholders with efficient and powerful financial analysis
• Optimise analysis of tariffs, prices, debt repayments, capital structures and more
• Review and understand VBA code in third party financial models




Accreditations / Prerequisites
Course Accreditations:

Course Prerequisites:

Related Courses

Related Courses:

82 visited

People Visited:

82 people visited

BOOK THIS COURSE

Select Dates

Monday, 17 Sep 2012

Add Attendees (Min 1 and Max 10)




Attendees x 0

Add To Cart

Selected Course Date:

Course Attendees:

PRICE / Person:

$3,575.00

You have no items in your shopping cart.

Recently Viewed

  1. Performance Test Management

  2. Negotiation not Concession

  3. Microsoft Word 2010 Level 2

  4. Microsoft Word 2010 Level 1

  5. Visio Professional 2007 - Introduction / Intermediate

Compare Courses

You have no items to compare.


Copyright © 2012 mytraining.net Pty Limited. ABN 90 139 474 070 All Rights Reserved.