$1,050 – $1,200

The Marquee Group - 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.

Eligible for CFA & CPA professional development hours.


Date & Time
January 23 & 24, 2019
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.


Registration Deadlines

Early Payment Pricing: $525 + tax (if registration paid by January 9, 2019)

Regular Pricing: $600 + tax (registration closes on January 18, 2019)


*Please note that student pricing is available. To obtain a 40% discount, please email a scanned copy or photo of your student ID that clearly shows your name and expiration date to info@marqueegroup.ca. Once we confirm your status as a current full-time student, we will provide you with a student discount code.

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