close
You are not logged in
close
This Month Specials
 

Special Promotion

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

PowerPivot Fundamentals $199 (Normally $299)

$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)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Excel Programming with VBA

$545

SessionPriceSeatsLocation
May 12, May 13: 9:00am–5:00pm$54512185 Madison Avenue, NYC
May 14, May 16: 9:00am–5:00pm$5459185 Madison Avenue, NYC
Jun 6, Jun 7: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Jun 23, Jun 24: 9:00am–5:00pm$54512185 Madison Avenue, NYC
Jun 26, Jun 27: 9:00am–5:00pm$54510185 Madison Avenue, NYC

Call 212.658.1918 or email us

VBA Classes New York City

Excel Programming with VBA: In-Person VBA & Macros Classes

VBA (Visual Basic for Applications) is the programming language used in Microsoft Excel. With this programming language, you can automate repititive operations, create custom commands, develop new worksheet functions, and more. At NYIM's VBA classes in New York City, you will learn the fundamentals of VBA programming in hands-on, instructor-led training.

Our VBA classes include a Free Retake within six months of the course. 

Learn to Program & Create Macros in Excel

The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this VBA & Macros training course, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program. This VBA course is perfect for those consistently working with Excel who need to automate repetitive tasks.

Interactive and hands-on VBA training class

In this hands-on, instructor-led VBA training, you will work on real-world applications of Macros and Excel programming with hands-on exercises. In addition to extensive teaching experience, our instructors provide VBA consulting work and use examples and best practices from real-world projects in the class.

Excel VBA Classes

Excel VBA Training Benefits

  • Practical and hands-on training focused on real-world applications of VBA
  • Engaging and interactive instructors
  • Custom VBA training manual
  • Small class sizes for personalized attention

VBA Course Outline

VBA Course PDF Outline

1. Macros 6. Strings 12. Worksheets
What are Macros? How to reference a string Selecting a specific worksheet
How to record macros Concatenating strings Selecting the active worksheet
How to run macros 7. Declaring variables Adding a new worksheet
How macros are related to VBA How to declare variables Naming a worksheet
2. VBA Editor Using "Option Explicit" Range
What is VBA? Declaring multiple variables Selecting a range of cells
How to edit VBA code Requiring variable declarations Avoiding variant declaration
"Sub" routine 8. Types of Variables When to use variant
Project Explorter String, Single, Boolean, Time 13. IF Statements
3. Turning on Project Explorer Integer, Double, Date, Variant If Then statements
Excel objects & modules 9. Properties If Then Else statements
Excel objects What are properties? 14. Referencing & Manipluating Cells
Modules Renaming modules Selecting a specific cell
Making a hidden sheet Renaming sheets Selecting the active cell
4. Comments Watch window Deleting cell contents
What are comments? Using watch windows 15. Activating Scripts 
How comments are marked 10. Rows Workbook_Open
Importance of comments Selecting a specific row Auto_Open
5. Debugger Selecting the active row 16. Loops
What is the debugger? Selecting the last row Do While Loop
How is it used? Insert a row For Next Loop
Step into Deleting row contents For Next Loop with Step
Step out 11. Columns Do Until Loop
Play Selecting a specific column For Each Loop
Reset Selecting the active column  
Step over Selecting the last column  
Play Insert a column  
Breakpoint Deleting the column contents  
Monitoring values    

Corporate VBA Training

Flexible training solutions & customized course content

Over two decades, NYIM has served the most prestigious businesses and institutions across the United States with its industry-leading VBA corporate training program. For our corporate clients, we can customize the VBA training to meet the needs of your team, and conduct the classes at your location or ours. We offer a free consultation to customize the content. For flexible scheduling options for your employees, ask about our voucher program.

Inquire about corporate VBA classes

Rated the Best VBA Classes in NYC

See for yourself why NYIM is rated the best VBA courses in Manhattan by our customers:

100+ 5-star Reviews on Yelp: Best VBA Classes NYC

“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.”
“Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.”

FAQ & What You’ll Learn in our VBA Classes

What is VBA?

VBA stands for Visual Basic for Applications, the programming language Microsoft Office is built on. Each application on the MS office suite – Excel, Word, PowerPoint etc. – has its own version of VBA.

What is a Macro?

A snippet of code that is going to perform or automate a set of tasks for a user.

In Excel, a macro can be recorded using the macro recorder in the Developer tab, or coded by hand in the Visual Basic Editor. You can create macros to perform more complicated series of tasks than what the defaults in Excel allow for.

When can or should you use VBA?

If you’re doing something in Excel that’s redundant, slow, boring, tedious, and most of all, something that has multiple elements to it where the sequence matters, VBA can help you automate that workflow.

VBA can enhance the capability of Excel; you can write code to expand the basic functionality of Excel beyond the standard defaults. With VBA, you can program your own functions, automate processes, and automate frequently used sequences of commands.

What are the major topics you’ll learn in our VBA classes?

  • Security
  • Recording macros
  • Reading and analyzing code
  • Programming basic macros
  • Create more complex macros
  • Variables
  • Looping statements
  • Logic statements
  • User Forms
  • Error Trapping
  • Troubleshooting

How are our VBA courses structured?

The VBA classes are hands-on and project based. You’ll be working on a larger project throughout the class by solving and completing one step before moving to the next. We break down larger projects into smaller pieces to facilitate learning and retention.

See More Excel & VBA Classes at NYIM

All Excel Classes Beginner Intermediate Advanced Fast as Hell Certification

© 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