Wall Street Prep
Wed Nov 4, 1-5p (ET)

Introduction to Excel VBA 4-Hour Virtual Power Session

Format: Live Virtual
Date: Nov 4
Time: 1-5p (ET)
CPE Credits: 4.5
Date doesn't work? Start Learning Now Online

Unlock the Power of Excel VBA

  • Start Writing VBA From ScratchGet 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 JobWe'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 NeededDesigned for complete newbies and/or those looking for a refresher. No prior programming knowledge is needed
FREE access to our Online VBA CourseAttending this program gets you a lifetime resource: The Ultimate Excel VBA Course. Dive even deeper into the world of Excel VBA with this comprehensive online course.

What You'll Learn

Introduction to VBA

  • Overview of Visual Basic Editor
  • Recording Macros
  • Recording with Relative References
  • Writing and Editing simple code
  • Assigning your code to buttons
  • Creating Keyboard Shortcuts
  • Using the VBA Object Browser
  • Financial Application: Calculate asset returns quickly by recording and running a macro.

Procedures and Functions

  • Create a User-Defined Function (UDF)
  • Working with Modules
  • Writing and Editing Functions and Subroutines
  • Declaring Variables
  • Variable Types
  • Utilizing Excel functions inside VBA code
  • Debugging VBA
  • Financial Application: Create a simple function related to CAPM and more complex functions like those related to M&A deals.

Looping

  • Repeat a series of actions by using loops such as For…Each…Next
  • Recursive syntax within code
  • Looping through Collections of Objects
  • Financial Application: Build a Payback Period Calculator using loops.

Please note that this power session is an abbreviated version of our 2-day seminar, which covers additional topics such as working with Large Datasets, Input Boxes and Messages Boxes, Userforms and Controls and Querying data and using SQL in VBA and associated exercises.

Show More Show Less

Wall Street Prep training is used at ...

clients clients

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 Excel skill set

Boot Camp Details

Revisit what you learn This virtual seminar will be recorded and available for you to review any time from your Wall Street Prep learning dashboard.
Overview

This boot camp is an 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 be introduced to the VBA environment and star learning how to unlock the secrets of automation and efficiency in Excel VBA using real world finance-related exercises. No prior programming knowledge is needed.

Experienced Instructors

Our instructors are all practitioners with years of directly relevant real- world experience and have a passion for teaching. They understand the importance of teaching in a way that empowers students to apply the lessons from the classroom directly on the job.

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.

Show More Show Less

Trainee Reviews

"The course is extremely efficient and useful. One of the best instructors I have had. She was very pleasant, extremely effective, and dedicated to answering all questions and providing super clear explanations."
Louis L.
"VBA and Macros are useful, and the instructor is excellent at explaining concepts and demonstrating examples as well as clarifying students' questions. There is hardly anything to improve upon!! Much better [compared to other courses taken]."
Bao Tuan N.
"This was a great introduction to the VBA capabilities and techniques that we can use to manage repetitive tasks and manipulate large data pools"
William C.
"The course content, structure, and presentation took on an otherwise intimidating subject and made it super simple."
Mike Y.
"Made me realize how underutilized VBA is and and how much it would help improve automation in my company. Thanks WSP!"
Jessica F
"Very useful in understanding what macros are and learning how to create and use them."
Shehzad

Why attend a boot camp?


  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.


  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.


  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.


  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.


  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.


  • Continuing ed & webinars

    Enrollment to most boot camps includes access to our continuing education online training platform and webinar series.

Can't Attend? Start Learning VBA Now Online

  • Learn how to save a ton of time in Excel with the easy-to-use VBA programming language
  • Full VBA Certification Program with 9+ Hours of Video Training
  • Start writing VBA code that you can immediately use on the job. No programming experience needed!
CPE logo

Earn 4.5 CPE Credits for this Seminar

CPE logo Wall 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.

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685









X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.