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
Jun 26, Jun 27: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Jul 16, Jul 17: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Aug 6, Aug 7: 9:00am–5:00pm$5458185 Madison Avenue, NYC
Aug 18, Aug 19: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Aug 30, Aug 31: 9:00am–5:00pm$5459185 Madison Avenue, NYC
Sep 20, Sep 21: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Oct 6, Oct 7: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Oct 15, Oct 16: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Nov 1, Nov 2: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Nov 28, Nov 29: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Dec 8, Dec 9: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Dec 17, Dec 18: 9:00am–5:00pm$54510185 Madison Avenue, NYC
Show more

Call 212.658.1918 or email us

VBA Classes New York City

Learn Excel Programming in Hands-on VBA Courses

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.

The Excel Programming with VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this Excel VBA 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 class is perfect for those consistently working with Excel who need to automate repetitive tasks.

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 Training Benefits

  • Practical and hands-on training focused on real-world applications of VBA
  • Engaging and interactive instructors with VBA consulting and teaching experience
  • Custom VBA training manual
  • Small class sizes for personalized attention
  • Free Retake with six months

Excel VBA Classes

Read Aris B.'s review of NYIM Training on Yelp

VBA Course Outline

VBA Course PDF Outline

VBA Macros Day 1

1. Macros / VBA 6. Variables
What are Macros? Declarations
What is VBA? Option Explicit
How to record macros Data Types
How to run macros 7. Working with The Object Model
2. VBA Editor Worksheets
Modules Ranges: Rows, Columns, Cells
Procedures 8. Creating & Naming Objects
Project Explorer Naming conventions
Toolbars / Options Housekeeping
3. Creating / Editing Code 9. Navigation / Selection Techniques
Create Procedures Formula R1C1 Reference Style
Subs Offsets
Comments Range Names
4. Invoking Macros 10. Logic Statements
Hot Keys IF Statements
Quick Access Toolbar 11. Looping Statements
Call Command Do Loops
5. Compiling Code 12. Interactive Code
Stepping through code Input boxes
Reset Message boxes
Run 13. Error Handlers
  Preventing fatal errors and crashes

VBA Macros Day 2

1. VBA Editor 7. Creating & Naming Objects
Project Explorer Naming conventions
Properties Window Housekeeping
Modules 8. Navigation / Selection Techniques
2. Creating / Editing Code Absolute versus Relative Reference
Functions Offsets
Events 9. Logic Statements
3. Invoking Macros Nested IF Statements
Worksheet Buttons Case Statements
Customize Ribbon 10. Functions
4. Compiling Code Intrinsic Functions
Stepping through code User Defined Functions
Setting Breakpoints 11. Looping Statements
5. Variables For Each Next Loops
Declarations 12. Interactive Code
Option Compare Text User Forms - dashboards
Option Compare Binary Message Boxes
Lifetime and Scope 13. Error Handlers
6. Working with The Object Model Error numbers
Application Error descriptions

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

This class is both the best VBA training and value in NYC. The class is very small (I had only two other students in my session) which allows the instructor to provide very personal training. The syllabus is very thorough and involves real-world, complex scenarios: such as changing formulas and text on a worksheet and replacing text strings by using loops. I took this class as training for an applications developer position and found it to be worthwhile. The price is very reasonable and the classes don't take up the whole day either. I strongly believe this to be the best value in NYC while offering the least amount of disturbance to your work schedule.
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