212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on WordpressGoogle Places

Return to Excel

VBA

VBA

VBALearn to automate repetitive Excel tasks with macros and Visual Basic Applications. Learn to debug programs and extend macros with variables and For Next loops. Learn to use Excel functions programatically and create User Defined Functions (UDFs). Learn to work with object variables and array variables within For Each and Do While loops. Courses are hands-on and include practice exercises. Course includes a 240 page manual and access to videos of class online.

class schedules

Course Schedules

Individuals
July 14th-15th 9am
August 5th, 12th 9am
August 15th, 22nd 10am
Companies
Register 4 or more students for a discount – Choose two full days or four half days
Contact Us Or Click Here For A Quote
registerLength: 2 full days
Price: $549

Frequently Asked Questions

frequently asked questions

  • What time does class start?
    Weekday classes start at 9am
    Weekend classes start at 10am
  • Do I need to bring a computer?
    We provide a Windows computer.
  • Do I receive a certificate?
    Yes, upon completion you will receive an attractive gold foil certificate.
  • Are there any prerequisites?
    Ability to use a mouse and a keyboard. Familiarity with advanced Excel Index Match functions helpful.
  • Where are you located?
    31 West 34th StreetNear Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.
  • Can I retake the class?
    Yes, where most training has a time and retake limit we offer unlimited retakes.

About The Instructor

Glenn Harris is a Microsoft Certified Technical Trainer and Office Master Instructor with 20 years of classroom experience. He has published many training manuals on Microsoft products. NYC Training is the only class that offers programmed self-assessment labs and online access to videos of Glenn teaching class (to himself).
microsoft certified trainer
microsoft office master
certified technical trainer

Select Corporate Clients

AIGAmerican ExpressBarneysColumbia UniversityDouglas EllimanGoldman SachsHarvard ClubMRM McCannNBCRalph LaurenUBSUnivision

VBA Outline

pdf outlineDownload a PDF

  • Lesson 1: What is VBA
    • ProgrammingTerminology
  • Lesson 2: Macros
    • Record
    • Naming Rules
  • Lesson 3: Macros Break – Debugging
    • Introduction to the VB Editor
      • Getting Set Up to Code
    • Introduction to Object Oriented Programming
    • The Dot Operator
    • Debug Print
    • Object Browser
    • Debugging
      • Reset
  • Lesson 4: Variables
    • Implicit vs. Explicit Declaration
    • Variable Naming Rules
    • Local vs. Global Scope
    • Public vs. Private Scope
    • Constants
    • Variable Substitution
    • Variable Concatenation
    • Object Variables
    • Array Variables
  • Lesson 5: VBA to Navigate
    • Ranges
      • Select vs. Activate
      • Value
      • Offset
      • Autofill
      • Find the Last Row
      • Name
    • Cells
      • ActiveCell
    • Sheets
      • Navigate
      • Add
      • Name
      • Hide
    • Copy and Paste
    • Workbooks
      • Open One Workbook
      • Open Many Workbooks
      • New Workbooks
  • Lesson 6: VBA Program Control Structures
    • Anatomy of a Program
      • Call Statements
    • Pseudocode as an Outline
    • Decision Control
      • If Then Else
      • Select Case
    • Flow Control
      • For Next
      • For Each
      • Do While
      • Do Until
      • With End With
    • Loops:
      • Loop With Counters
      • Loop With Step
      • Loop Backwards
      • Loop Through A Scenario
      • Loop Through Rows
      • Loops Within Loops
      • Loop and Make Decisions With If
      • Loop to Parse
      • Loop to Concatenate
  • Lesson 7: Error Handling
    • Run Time Errors – Level 1
      • On Error
      • Ignore Errors
    • Run Time Errors – Level 2
      • Create an External Text File
  • Lesson 8: Speed Up VBA Code
    • Improve Performance of VBA Code
  • Lesson 9: Functions
    • Intrinsic Functions
      • MsgBox
      • InputBox
      • FileDialog
      • Now
      • Date
      • Text Functions
      • Logical Functions
      • VBA Only Functions
    • Non Intrinsic Functions
      • Write Excel Functions in Cells
      • Call Excel Functions in RAM
      • Write User Defined Functions
        • Save As Add-In
      • Functions in Loops
  • Lesson 10: Workbook Events
    • Double Click Event
    • The Intersection Operator
  • Lesson 11:
    • Object Variables
    • Array Variables
    • Do Loops and For Each Loops With Object and Array Variables
  • Lesson 12: Indefinite Loops
    • Emergency Exit
  • Lesson 13: Putting It All Together
  • Lesson 14: Excel Resources
  • Appendices:
    • VBA Passwords and Digital Signatures
    • VB Editor Keyboard Shortcuts
    • Key VBA Commands
    • Save As An AddIn
    • Windows Task Scheduler
Summary
Event
VBA
Location
Excel Class, 31 West 34th Street,New York City,New York-10001
Starting on
July 14, 2020
Ending on
July 15, 2020
Offer Price