Call 212-729-7216

Live VBA Training Online

vba training dates

VBA Training

Scheduleregister vba training

June 1st, 2nd, 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th
July 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th
August 3rd, 4th
8pm-10pm EST

vba training outlineVBA Training Online – Course Outline

  • Recording Macros
    • Edit a Macro
    • Create a Simple Program
    • Assign Macros to Shapes
  • Visual Basic Applications Training
  • Introduction to Object-Oriented Programming
  • Variables
  • Navigate from cell to cell
    • Navigate with Variables
  • Read and Write to / from a cell
    • Read and Write with Variables
  • Find Key Columns
  • Named Ranges
    • Create Named Ranges
    • Navigate to Named Ranges
    • Select Named Ranges
  • Locate the Last Row of Data to Process
  • Worksheets
    • Add Sheets
    • Name Sheets
    • Count Sheets
    • Hide Sheets
  • Looping Control: For / Next Loops
  • Decision Control: If / Then Statements
  • Handle Run Time Errors
  • The Message Box Dialog
  • The Input Box Dialog
  • Dialogs and File Dialogs
  • Intrinsic VBA Functions
  • Read and Write Formulas to Cells
  • Call Functions in RAM Memory
  • Write Your Own User Defined Functions
  • Workbook Events
  • Object Variables
  • Array Variables
  • Looping Controls: While / Wend, Do While, Do Until, For Each
  • Text Functions
  • Charts
    • Create Charts
    • Edit Charts
  • Pivot Tables
    • Create Pivot Tables
    • Modify Pivot Tables
    • Refresh Pivot Tables
  • Connect to External Databases
    • Read Existing Queries
  • Process a Folder of Files

VBA Training OutlineDownload The Brochure

 

register vba training