You are not logged in
This Month Specials

Special Promotion

$199 Excel or PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

(book before 12/31/16)


Current Sales Packages

1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel Programming with VBA

Excel 2010 Training Class Logo

The Excel Power Programming with VBA class concentrates on practical automation of repetitious Excel tasks and reports. By the end of the Excel training course, you will feel confident in writing macros to automate your Excel tasks even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase the functionality of the program. This Excel class is perfect for those consistently working with Excel who need to automate repetitive tasks.

Call 212.658.1918 or Email us

Class Perks

  • Practical and hands-on training classes
  • Proprietary curriculum refined by industry experts
  • Interactive courses taught by engaging instructors
  • Revolutionary video suite with premium content
  • Personalized attention in small class sizes


  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

Course Outline


  • What are macros
  • How to record macros
  • How to run macros
  • How Macros are related to VBA


  • What is VBA
  • How to edit VBA Code

    What is a “sub” routine

  • What is Project Explorer
    • How to turn on Project Explorer
    • Excel Objects and Modules
      • What are Excel Objects
      • What are Modules
      • Making a sheet hidden
  • Properties,
    • What are Properties and their purpose
    • Renaming Modules
    • Renaming Sheets
  • Watch Window
    • What is a watch window and how to use it
  • Comments
    • What are comments
    • How are comments marked
    • The importance of comments
  • Debugger
    • What is the debugger
    • How is it used
    • Step into
    • Step over
    • Step Out
    • Play
    • Breakpoint
    • Reset
    • Monitoring values


  • What are Variables
  • How to declare variables
    • Using “Option Explicit”
    • Declaring multiple variables
    • Requiring variable declaration
  • Types of Variables
    • String
    • Integer
    • Single
    • Double
    • Boolean
    • Date
    • Time
    • Variant
      • Why to avoid variant declaration
      • When to use variant


    • Selecting a specific cell
    • Selecting the active cell
    • Setting the value of a cell
    • Deleting cell contents
  • Rows
    • Selecting a specific row
    • Selecting the active row
    • Selecting the last row
    • Insert a row
    • Deleting row contents
  • Columns
    • Selecting a specific column
    • Selecting the active column
    • Selecting the last column
    • Insert a column
    • Deleting the column contents
  • Worksheets
    • Selecting a specific Worksheet
    • Selecting the active worksheet
    • Adding a new worksheet
    • Naming a worksheet
  • Range
    • Selecting a range of cells


  • How to Reference a string
  • Concatenating strings


  • If Then Statements
  • If Then Else Statements


  • Do While Loop
  • For Next Loop
  • For Next Loop with Step
  • Do Until Loop
  • For Each Loop


  • Workbook_Open
  • Auto_Open

© NYIM Training 2018

Client Testimonials
This course exceeded my expectations.Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.- Laura H. attended Excel Programming with VBA
Saba made the class non- intimidating and informative due to her casual approach, teaching from the basics forward and her helpfulness with every little question. I did like that the class was small and hands on with computers.- N.B. attended Excel Programming with VBA
Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.- V.B. attended Excel Programming with VBA
I don't even know what else Saba could have done to make the class better - she was so on point and really interesting. - L.P. attended Excel Programming with VBA
Thank you for the session! It was really helpful and I've learned a lot from Joe.- N.N. attended Excel Programming with VBA