↑ Return to VBA Training

VBA Training Online

VBA Training Online

We offer an exclusive 12 week 48 hour live VBA class online with recordings for you to review and homework for you to practice. Learn how to use Excel Visual Basic Applications (VBA) to automate repetitive Excel tasks or modify other programmers VBA code. The Online VBA Course restarts every quarter and runs twice a week for two hours. If you cannot attend the live webinars you can review the videos of the class online with no time or usage limits. Unlimited free retakes. Our class includes hundreds of pages of color electronic notes and visuals, dozens of example code snippets, dozens of workbooks, and dozens of homework assignments to practice between classes. Call 212-537-6125 to learn more!

VBA Class Schedules

register training

FULL
September 11th, 12th, 18th, 19th, 25th, 26th
October 2nd, 3rd, 9th, 10th, 16th, 17th, 23rd, 24th, 30th, 31st
November 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th
7pm-9pm EST

2019
March 4th, 5th, 11th, 12th, 18th, 19th, 25th, 26th
April 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th
May 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th
7pm-9pm EST

 

Excel VBA Online Training Topics

Our Online VBA training takes a different approach than most VBA classes. Instead of only teaching you VBA syntax (spelling) i provide context to why, when, where, and how to use those words to solve your own Excel automation projects. My objective is not for students to learn the full 65,000+ word VBA vocabulary. Rather, I will teach you 60 essential words to get you going and when you need other words you may be able to record a macro to uncover their syntax and usage. If that doesnt work I will show you websites where you can ask for assistance 24 hours a day 7 days a week.

Based on years of teaching VBA and developing VBA solutions for my clients, I believe VBA fundamentals includes coverage of the following topics:

  • Review of Advanced Excel Topics
  • Keyboard Shortcuts for Common functions
  • Named Ranges
  • Functions: Vlookup vs. Index/Match, If, Sumifs, Countifs, Count vs. Counta
  • Pivot Tables
  • Data: Filters, Extract Unique, Validation, ODBC Data Connectivity (Windows only)
  • Recording Macros ? Strengths and Weaknesses
  • Editing Macros with the Visual Basic Editor
  • Debugging
  • Writing Pseudocode
  • Declaring Variables
    • Variable Data Types
    • Variable Concatenation and Variable Substitution
  • Navigating Cells and Ranges
  • Navigating Worksheets
    • Add Sheets
    • Name Sheets
    • Count Sheets
    • Hidden Sheets
  • Finding Key Columns
  • Read and Write to / from Cells
  • Use Named Ranges to Demarcate Start and End Positions
  • Use For / Next Loops to Iterate Through Cells and Ranges
  • Use If / Then / Else Statements To Make Decisions
  • Make Code Run Faster
  • Handle Run-Time Errors Level I
  • Message Box, InputBox, Dialogs and FileDialogs
  • Use Excels Functions
  • Write Your Own Functions
  • Workbook Events
  • Create Programs That Run On Specified Days and Times Automatically
  • Select Case Control Structures
  • Pass Local Variables vs. Use Global Variables
  • Call Subroutines From Subroutines, Pass Local Varaibles
  • Array Variables
  • Object Variables
  • For Each Loops
  • Do While Loops and Do Until Loops
  • While / Wend Loops
  • User Forms
  • Charts
  • Pivot Tables
  • Communicate With Other Microsoft Programs
  • Handle Run-Time Errors Level II ? Write to External Text Files
  • Connect to Databases, Read and Write
  • Class Modules
  • Import a Folder of PDFs to Excel Sheets