Other Industry Event, Other Industry Events, Virtual Events & Programming

Excel Visual Basic (VBA) for Finance – Wall Street Prep

October 14, 2020 - October 15, 2020

Share Event

Loading Events

Wait! A Note on Registration:

We’ve launched Cvent—our new events platform!

Registration for any event with a start date after Sept. 28 now requires a CFA Institute account.

I don’t have a CFA Institute account

  • No problem! You’ll have the chance to create one prior to registration.

I already have a CFA Institute account

  • Great! Be sure to use your existing credentials at registration.
Cvent Transition Guide

Presented by Wall Street Prep, learn VBA in 2 days and start putting Excel on autopilot!

What You’ll Learn

This boot camp is an intensive instructor-led training program that will teach you how to take Excel by the horns and make it do whatever you want through a simple but effective tool called “VBA.” Trainees will learn how to unlock the secrets of automation and efficiency in Excel VBA through real world finance-related exercises. No prior programming knowledge is needed.

Learn to use Excel VBA like a pro; no coding experience needed!

  • Learn the secrets of VBA
  • No coding experience needed
  • Real-world finance exercises
  • Network with professionals

CFANY.org: $1,039
Standard Rate: $1,299

VBA: A whole new level of Excel efficiency

Formulas & shortcuts can’t do everything — use VBA when you reach a limitation

Reduce time-consuming spreadsheet work to the click of a button

Come away with practical code you can use in your own spreadsheets

Complete real-world Macro/VBA projects from start to finish

Understand VBA enough to alter code you find online to fit your purpose

Real-world applications of VBA programming for finance

Additional Details

Who is this boot camp for?

  • Investment banking analysts and associates
  • Private equity, asset management and hedge fund associates
  • Corporate finance and business development professionals
  • MBA students and business undergraduates
  • Anyone seeking to improve their financial modeling skill set

Boot Camp Details

This boot camp is an intensive virtual training program where trainees learn financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.

Virtual training runs daily from 8am to 5pm. The day will be filled with interactive exercises as learners move back and forth between classroom lecture, small group breakout rooms, competitions and 1-on-1 interaction.

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar.