Wall Street Prep
The Ultimate Excel VBA Course

The Ultimate Excel VBA Course

Full VBA Certification Program with 9+ Hours of Video TrainingStart writing VBA code that you can immediately use on the job. No programming experience needed!

Why you should take this course

What You'll Learn
Write macros from scratch
Write custom formulas & functions on the fly
Breeze through IF THEN statements and conquer all the logical operators
Take control of forms, buttons, drop-downs and much more!
  • For finance professionals, speed in Excel is not only a requirement, it's a big part of how you're measured against your peers.
  • This comprehensive course is designed to teach students and professionals how to save a ton of time in Excel with the easy-to-use VBA programming language.
  • We'll introduce you VBA environment and dive into real-world exercises that will teach you how to write your own macros, functions and subroutines and how to breeze through large data sets with ease!

Who is this program for?

This course is for Excel VBA newbies as well as those looking for a VBA refresher or reference tool. It's designed to give a competitive edge to students and/or professionals who rely on Excel, including:

  • Investment banking analysts and associates
  • Private equity, asset management and hedge fund associates
  • Corporate finance and business development professionals
  • MBA students and business undergraduates

Wall Street Prep’s Ultimate Excel VBA Course is used at top financial institutions and business schools.

Course Samples

watch video
Creating your first macro from scratch
watch video
If, Then, Else Statement
watch video
Using an InputBox

VBA Exam and Certification

Course registration comes with access to a 2-hour certification exam. You are eligible to take the exam for 24 months from the date you registered for the course. Those who complete the exam and score above 80% will receive a Certification in Visual Basic for Excel. This exam is thorough and challenging. A passing score demonstrates proficiency with the topics covered in this comprehensive course.

Course Highlights

  • Perfect for both Excel newbies and experts interested in VBA.
  • Absolutely no programming experience is needed.
  • Full of VBA techniques used by finance professionals.
  • 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.
  • A great learning and reference tool: 150+ individual VBA lessons!
  • The same course our corporate clients use to prepare their analysts and associates.

Full Course Agenda

    The Range Object open
    • Get the Developer Tab and Intro to Developer Tab
    • Getting Started With Range Object
    • Creating Your First Macro From Scratch
    • Adding a Secondary Command
    • Debugging in Excel VBA
    • Saving a Macro-Enabled Workbook (.xlsm)
    • Several Ways to Trigger Your Macro
    • Affecting Multiple Cells with One Range Command - 2 Methods
    • Adding Strings of Text to a Cell
    • Using a Named Range with the Range Object
    Range Properties open
    • VALUE Property
    • TEXT Property
    • ROW and COLUMN Properties
    • SELECT Property
    • COUNT Property
    • ADDRESS Property
    • FORMULA Property
    • NUMBERFORMAT Property
    • FONT, BOLD, UNDERLINE or ITALIC Properties
    The Cells Object open
    • The Cells Object
    • Using Column Letters Instead of Numbers
    • Using Cells Positionally Within a Range
    • Affecting ALL Cells in a Worksheet
    • Using Range Object with Cells Object
    Variables open
    • Intro to Variables
    • Declaring Variables - Variable Types
    • Declaring Variables - Types Demo
    • Calling a Procedure from Another
    • Public and Private Variables
    • Using Constants
    Toolbars and Menus open
    • File Menu Walkthrough
    • Edit Menu Walkthrough
    • View Menu Walkthrough
    • View Menu - Watch Window, Local Window and Immediate WIndow
    • Watch Window Wonders!
    • Insert and Format Menus
    • Debug Menu
    • Run and Tools Menus
    Important Tools and Excel Logic open
    • Determining the Last Row in your Data Set
    • Determining the Last Column in your Data Set
    • Determining the Next Row in your Data Set
    • Recording a Macro
    • Absolute vs. Relative References
    • Using With and End WIth
    • Comparison Operators in Excel VBA
    • If Then Statement
    • Using Is Not Equal To ()
    • Logical Operator, NOT
    • If, Then, Else Statement
    • If, Then, ElseIF Statement
    • Comparative Operators with Text and Numbers
    • Using If Then Statements in a One-Liner of Code
    • Using GOTO and Labels
    • Select Case as Alternative to IF THEN Statements
    • Message Box with Yes and No Buttons
    • Relative Positioning Using Offset
    Loops and Report Writing Basics open
    • Intro to Loops; the For Next Loop
    • Fun with out For Next Loop
    • Beginning out First Report Using Loops
    • Using an InputBox
    • Adding InputBox to Our First Report to Make It Dynamic
    • Add a Button to Open Our Report
    • Add a Cool Button or Image to Open Report
    • Our First Printable Report, Part 1
    • Printable Report, Part 2
    • Printable Report, Part 3
    • Printable Report, Part 4
    • Using PrintPreview Automatically
    • Using PrintOut to Send Directly to Default Printer
    • Handling Debug Error When Cancelling InputBox
    • For Loop Going Backwards Using STEP
    • The FOR EACH Loop
    • FOR EACH Loop - Practice Examples
    • Intro to DO LOOPS
    • DO Until
    • Loop Until
    • DO While
    • Loop While
    • EXIT DO - Multiple Exits Using Your Own Criteria Along the Way!
    Events, Worksheet Events Made Easy open
    • Intro to Worksheet Events and Selection Change
    • Worksheet Activate Event
    • Worksheet Deactivate Event
    • BeforeDelete Event - For Worksheet Deletion
    • BeforeDoubleClick Event - Trigger a Macro When Double Clicking
    • BeforeRightClick Event - Trigger a Macro When Right-Clicking
    • Calculate Event
    • How to Disable Events on the Workbook
    • Intro to Change Event
    • Change Event with EnableEvents Toggle - Avoid Endless Loop!
    • Change Event Triggered With Custom Range Using Intersect
    • FollowHyperlinks Event
    • Final Thoughts on Worksheet Events and Review Other Events
    Workbook Events open
    • Workbook Open
    • Workbook Activate
    • Before Save
    • After Save
    • Before Close
    • Before Print
    • Deactivate
    • NewChart
    • NewSheet
    • Sheet Activate
    • Delete, DoubleClick, RightClick, Calculate, Change
    • SheetDeactivate
    • Follow Hyperlink
    • SheetSelectionChange
    • WindowActivate
    • WindowDeactivate
    • WindowResize
    Activex Controls of Worksheets open
    • Activex Controls vs. Forms Controls
    • Button Click - Wage Calculator
    • Keydown Event
    • BONUS: Capturing Shift, Alt, Ctrl or Some Combination Using the Shift Variable
    • KeyPress Event
    • MouseMove Event
    • MouseMove Event with Application Statusbar
    • MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl
    • GotFocus and LostFocus Events
    • Use a Checkbox for its VALUE
    • Checkbox Event Without a Button
    • LinkedCell Property With a Checkbox
    • Option Buttons Intro - What is an Option Button and Grouping
    • Grouping, Alignment and Aesthetics for Control
    • Homemade Quiz Using Option Buttons and a Command Button
    • Compliance Checker for Your Forms or Quizzes, Part 1
    • Compliance Check, Part 2
    • SpinButton With Cell A1
    • SpinButtons With Textboxes and Numbers
    • SpinButton BONUS - Move Textbox Position with SpinButton
    • SpinButton With Dates in a Textbox
    • Activex "Label" Control - Basics
    • ComboBox - Fill With ListFillRange
    • Creating a Dynamic Range
    • ComboBox - How To Use Multiple Columns
    • Using ADDITEM to Get Specific Items in Your ComboBox List
    • Noteworthy Properties of a ComboBox
    • Multiple Columns in ComboBox With ADDITEM and List, ListCount, etc.
    • ListBox Basics Using Dynamic Range
    • ListBox Click Event and Dynamic Options
    • ListBox - Referencing Column 0 and 1 in a Cell Dynamically
    • Dynamic ListBoxes Using ADDITEM and More
    • Make and Utilize INVISIBLE Columns - Special Trick!
    • Using Scroll Bar on a Worksheet
    • Pictures on a Worksheet, Plus Using FollowHyperlink Method
    • Toggle Button
    • A Brief Note on Alternate, 3rd Party Controls
    Userforms - The Best Thing Ever! open
    • Userform - Hide, Show and Unload
    • Simple Database and Creating a Data Entry Form
    • Fill Status ComboBox With Rowsource When Userform Starts - 2 Methods
    • New Employee Data Entry Form
    • Format Textbox Numbers as Numerals, Clearing Out Form Upon Submission
    • Set the Tab Order for Userform Controls
    • Set Default Values to Make Data Entry Easier
    • Avoid Duplicate Employee ID and Other Fun Automation Tricks
    • Edit Mode for Employee Database, Part 1
    • Edit Mode for Employee Database, Part 2
    • Edit Mode, Part 3 - Adding Automation and Save Button
    • Userform Report with Filters, Part 1
    • Userform Report with Filters, Part 2
    • Applying the Dynamic Filters to Reports
    • Clear Out Last Report
    • Report Generation and Aesthetics, Headers, Footers, Footers, Repeat Rows, etc.
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.

We are currently experiencing intermittent outages. If you are on the site when an outage occurs, please check back in 10-15 minutes. We greatly appreciate your patience as we work to resolve this issue.