$1,050 – $1,200

VBA for Finance Professionals

Event Information

Share this event

Date and Time

Location

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This advanced hands-on course focuses on the skills needed to harness the power of macros to help automate worksheet processes. Participants will learn to design, build and error check macros that are robust and easy to use. Participants will be introduced to best practices using VBA (Visual Basic – the programming language for macros) and the construction of powerful, error-free macros.

Topics Include

Using Macros in a Model

  • Explore macros and Excel’s development tools
  • Explore macros and Excel’s development tools and learning to use the VBA Editor (ie. the Code, Project, Properties and Immediate Windows)
  • Develop subroutines and the ability to organize and execute actions within Excel with well-designed VBA code


Writing Code for Macros

  • Design sample macros and reinforce best practices for programming robust and error-free VBA code
  • Build and audit looping techniques to perform repetitive actions and automated decision choices
  • Customize Excel using VBA in order to create highly tailored solutions such as custom functions and to control the user experience with features such as user input forms, special controls and macro buttons


Macro Creation

  • Build and test sample macros that automate common capital markets activities and give the user a chance to explore various capabilities
  • Create a number of functional macros including a data scrubber, dynamic range creator, table formatting, graphing macros and automated data updates


Who Will Benefit
Anyone who wants improve their ability to automate routine processes to save time and effort. This program would be especially useful for those involved in reporting where summarizing data in a consistent manner is important.


Date & Time
April 18 & 19, 2018
8:30 am to 5:00 pm


Special Instructions

  • Participants should have a strong working knowledge of Excel. Previous exposure to computer programming is beneficial, but not required for the course.
  • A laptop with any version of Excel is required for this course.
Share with friends

Date and Time

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved