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

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

Tuesday, June 8 - Wednesday, June 9

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, Unlock the Power of Excel VBA in this 2-day intensive virtual boot camp

What You’ll Learn

Start Writing VBA From Scratch
Get up to speed with the VBA environment and dive right into some real-world exercises that will teach you how to write your own code including macros, functions and subroutines.

Immediately Use VBA on the Job
We’ll show you how you can start using macros in a finance setting by running through real-world exercises such as calculating asset returns and building a payback-period calculator.

No Coding Experience Needed
Designed for complete newbies and/or those looking for a refresher. No prior programming knowledge is needed

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

Agenda

Please note: Each daily session goes from 9AM – 5PM EST


Day 1 | THE VBA ENVIRONMENT; START WRITING YOUR OWN CODE!

On Day 1, we’ll bring trainees (including first-time programmers) up to speed with the VBA environment and dive right into some real-world exercises that will teach you how to write your own code including macros, functions and subroutines.


Day 2 | REAL-WORLD APPLICATIONS OF VBA FOR FINANCE 

On Day 2, we’ll dive right into exercises that show how finance professionals can save tons of time automating tasks. We’ll show you how to tackle large data sets with ease, how to build your own userforms and controls and how to query a database.


Online | PRE-SEMINAR EXCEL TRAINING

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Additional Details

Who is this boot camp for?

  • This boot camp is designed for anyone who wants to learn VBA and add Excel automation to their skill set.  Given Wall Street Prep’s client base, attendees tend to come from the following backgrounds:

    • Financial planning and analysis and treasury
    • Corporate finance and business development
    • Credit analysts
    • Quantitative finance and trading
    • Sell-side / buy side analysts

Boot Camp Details

This boot camp is an intensive instructor-led training program where trainees learn the secrets of Automation and Efficiency in Excel VBA using an intuitive, step-by-step approach. Participants will write subroutines and user-defined functions in VBA in a fun and energetic setting. We will build templates that can quickly turn large obscure data files into clean, elegant reports. We will learn iteration methods to dramatically increase productivity. Participants will also create user interfaces and build data entry forms to interact with Excel users. No prior programming knowledge is needed.

This virtual training session will run from 9a-5p daily (ET). The session will use interactive exercises as learners move back and forth between classroom lecture and small group breakout rooms.

What’s Included?

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.


Virtual Training Sign-In and Setup

Instructions on signing into this virtual session will be sent to you prior to the event date. Learn about technical details and more at our Virtual Training FAQ.


CPE Credit
Earn 18 CPE Credits for this Seminar

CPE logoWall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.


Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.