VBA Classes in NYC or Live Online

Hands-on VBA training courses in Manhattan, NYC

Learn to automate daily work in Excel using VBA (Visual Basic for Applications), the programming language of Excel. In our instructor-led VBA courses in NYC, we'll review how to develop a macro, use loops and conditions, and create VBA scripts.

  • In-person courses
  • Flexible training solutions
  • Small class sizes
  • Hands-on & interactive

Small Group VBA Classes

Our VBA Classes courses are instructor-led in our Manhattan classrooms or live online (virtual learning).

Corporate Training

Drive team performance and efficiency with Career Centers’s industry-leading training. Send employees to our group classes or create a custom training program onsite.

Get a Free Quote

Why Learn at Career Centers

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

Our VBA Classes are rated 4.8 stars by 7,553 students

in the past 24 months

This Excel for Business Bootcamp was intense but informative. I learned a great deal and so many shortcuts. Thanks Shubhi, you were great.

Even taking a class like this online, I feel I received the most benefit from the material. Everything was provided and easy to navigate.


NYU Grossman School of Medicine

I have learned a lot from this course.


NYU School of Medicine

Mike was a fantastic instructor and was very attentive to any student questions.


Hinds-Bock

Excellent course for a great value. I am a business analyst for a Fortune 100 company and the concepts I improved on in this class will both improve the quality of my work and boost my team's productivity.

The best, most engaging Excel course I've taken to date! Mike was absolutely fabulous. I took the intro Excel course with him and was so excited to see that he was teaching this course today! Mike isn't just an exceptional instructor, but also a master at engaging his students. His teaching style is the perfect mix for me: keeping the topics light while introducing game-changing knowledge and insights.

Garfield is great. I enjoyed his instruction and learned a lot about the structure of Excel VBA.

I would recommend the Excel training classes at NYC Career Centers. If you are looking to enter back into the job market or just want to update your skills - then NYC Career Centers is the place to do it. The teachers are well versed in their courses and have a helpful attitude. The school is centrally located in NYC. The classrooms are extremely clean. They offer both online and in-person classes. Listen, it is time to go for it!!!!

As a long-time user of Excel in both my professional and personal life, I was apprehensive on what I can learn from an instructor-led course on such a specific topic as Visual Basic that I couldn't learn by watching YouTube videos. The instructor and class interactions helped me learn how to approach solutions using this tool. I would highly recommend these courses to my peers who are interested in expanding their knowledge base.

The class was thorough and interactive!

Perfect for anyone who uses Excel in their day-to-day life! Learned many new shortcuts for Excel and my new favorite: the XLOOKUP.

Great instructor, would definitely recommend for new users. Awesome!

I came in knowing nothing about VBA and macros. I left with a sufficient enough understanding to continue mastery at home or in the office!

Mike G. helped learning about macros and some of the more advanced functions in Excel truly interesting! He taught the course in a personable, fun way that really destroyed the bad rep that Excel gets as 'boring' and 'impossible.'

I loved the instructor's style and real-life integration. It assisted in my learning and absorption. The class had very informative, relative, and actionable content. I would recommend this to all my peers.


OVED

I really loved the follow-along workbook. It made it easier to understand and learn the new functions being taught. I especially love that we have it for future reference when attempting to utilize the new tools learned.

This class was great! I am excited to implement what I learned in my work.

I only wish I'd taken these courses earlier - so much of what I've learned would have made me far more efficient in my job. I look forward to using these skills and hope to take more classes from NYC Career Centers.

Overall, highly recommend.

Debbie made this class. How she got these tough concepts to stick in my brain I'll never know, but I'll always be grateful as it is going to give me back so much time in my work!

As a self-taught Excel user for many years, this course is a great way to fill in blanks, understand why things work the way they do, and move you forward in ways you may never have been able to on your own.

If the class is about Excel and if the instructor is Debbie Cunningham, TAKE IT. Even if it's just a refresher course, I promise it will be both informative and enjoyable.

Solid introductory course if you have never opened VBA Editor. You will learn how to navigate the UI and write your very first Excel code.

I have used Excel at work for years but I picked up so many tips and learned new functionality. I will be much more efficient after this class!


TMc

Really enjoyed this course. Super succinct and covers a wide range of topics.


L'Oreal

OMG! Ade was an excellent instructor! He explained things in a very clear way; he was thorough yet not overwhelmingly so. Definitely would recommend.


Ortho Clinical Diagnostics.com

Very good! Day 2 of a 2 day course - really did not think the instructor (Peter) could have been better than day 1 instructor (Ade). While they are different, they are both great! I really appreciate the time Peter spent on the difficult topics today. Made them very simple to understand which will really help with recollection!


Ortho Clinical Diagnostics, Inc.

Great class if you're looking to enhance your professional skills!


David Yurman

I feel confident about VLOOKUPs now after attending this course.


Lazard Asset Management

Great class! Definitely excited to take these tips into the workforce.

Small class sizes, patience experts with real life experience, and the opportunity to retake a course in 6 months! They really want you to succeed!


Point B

Great overview of basic Excel functions.

I am now an Excel Guru, no doubt!


MealCo

Here to Learn - Earn with what your Learn!


Mitsubishi Corporation

Really good way to get groundwork for VBA coding. Fast pace, real-world examples.

I've been taking classes here over the course of many years. Convenient location, class schedule availability, individual attention, reasonably priced. Great opportunity if you want a classroom setting.

I initially took this class for VLookups and Pivot Tables, but there were so many useful tools just for everyday tasks in the office. I would recommend this class to anyone. I'll be back for Advanced Excel. Thanks!!


Breaking Ground

An excellent start to put you on the right track toward your journey to software mastery.

The perfect boot camp to refresh my skills while also learning new, helpful tips! Great for beginners and experts alike. Would definitely take another class and recommend to other peers and colleagues.

Very interactive, great way to build skills with Excel.

Helped me distinguish my strengths and weaknesses in Excel and really advanced my skills and understanding of the software.


N/A

This class was very helpful & the instructor was very knowledgeable on the subject. The class was very interactive and I would 10/10 suggest it to others.


Moody's Analytics

Whether you are looking to firm up your skills, learn new skills, or just get faster and more efficient at the skills you already have, this is a great training experience!


Uplift Education

Garfield's class was so informative, I would definitely return for refresher classes if I ever need to sharpen my skills. HIGHLY RECOMMEND!


Natixis

Great class, taught me things about excel that I will definitely use in my profession.

One of the best Excel classes that I have taken.


NYC DDC

Highly recommend to anyone looking to build technical skills in Excel.


NYU

Would highly recommend to anyone interested in improving their Excel abilities. Garfield is particularly wonderful.

Amazing class. I needed a refresher on this information, especially Pivot Tables and macros. I loved Jordan's knowledge, professionalism, and personality. He made all of this information so much easier to understand. Thank you!


adidas AG

I did the all day class on a Sunday. I thought it would be a long grueling day, but it was actually enjoyable and went by really fast.


Merrill Lynch

Patrick is a fantastic instructor. This was my second time taking the Excel class with him. His pace is just right, he waits for every single person in the class to finish before he moves on to the next task and doesn't over-complicate things. He's always open to explaining again and sometimes shows shortcuts while he does that. His teaching style is incredible and I'd definitely recommend him.


Macy's

Liked the pace at which the class went and was able to cover all the concepts for the day.

Teaches tips and tools with step-by-step instructions that never leave you behind.


Idealist

Learned so many tips and tricks. Thank you!

The class session went very well. Ade does take the time to go through the lesson and allow students to ask questions.


Dept. of Environmental Protection-City of New York

Upcoming VBA Classes in NYC

All times are listed in Eastern Time unless otherwise specified.

October 2024
October 14–21
Mondays 6–9pm
$249
6 Hours
NYC or Live Online

Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

October 16
Wednesday 10–5pm
$249
6 Hours
NYC or Live Online

Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

October 21–23
Weekdays 10–5pm
$549
18 Hours
NYC or Live Online

Go from novice to expert in our three-day comprehensive Excel Bootcamp. You’ll learn advanced database functions, calculations, and formulas, shortcuts, Pivot Tables and scripts, and macros for automating tasks with ease. 

October 22
Tuesday 10–5pm
$249
6 Hours
NYC or Live Online

Take your Excel skills up a level with this Intermediate Excel course. Learn important Excel functions like VLOOKUP, SUMIFs, and Pivot Tables in this hands-on training. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation.

October 23
Wednesday 10–5pm
$249
6 Hours
NYC or Live Online

Become an expert Excel user with this Advanced Excel course. Learn powerful functions like INDEX-MATCH, work with advanced Pivot Table functions, and start recording macros to automate workflows. Prepare yourself for any Excel challenge with this advanced Excel course.

showing 5 of 59 courses

An Introduction to Visual Basic for Applications

Visual Basic for Applications (more commonly known as VBA) is a programming language that works with Microsoft Applications. Excel, Word, PowerPoint, and other applications have a unique variant of VBA designed to work with that program. With all of the buzz about coding languages like Python, Java, and JavaScript, you may wonder if you really need to learn VBA.

If you use Excel daily, especially if you complete the same tasks repeatedly, learning VBA is an investment that is well worth your time. VBA is used to write macros, which are blocks of code that automate repetitive tasks. You can write code with the VBA editor or Developer tab.

There are two specific use cases when you want to use VBA:

  • Conducting multi-step tasks that require you to sit at a computer for hours
  • Expanding the functionality of Excel to include a form or user interface

The benefits of using VBA include:

  • Reduce human error - with VBA, you’ll reduce human error by automating tasks
  • Increase your value - boost your role within the company as the resident Excel expert
  • Save money - Save money by saving time when you automate tasks with VBA
  • Learn quickly - You don’t need to learn new software; build on your existing Excel skills

Visual Basic for Applications Classes in NYC

At Career Centers, our VBA classes feature an interactive training model and job-focused VBA training. Our Excel programming with VBA courses help you to work more quickly and efficiently, regardless of how you use Excel. These classes are ideal for any Excel user that would like to reduce the capacity for error while speeding up workflow.

We cover a variety of topics in our Excel VBA courses, including the following:

  • Creating user forms
  • Evaluating code
  • Generating complicated macros
  • Maintaining secure worksheets
  • Making the most of troubleshooting
  • Understanding logic and looping statements
  • Using the macro recorder
  • Utilizing error trapping
  • Working with variables
  • Writing macros

Register for Excel VBA Classes in NYC at Career Centers

Career Centers offers the best value for VBA classes in NYC. When you register for VBA classes at Career Centers, you get more than just a training class. We provide software, hardware, and even light refreshments to keep you comfortable while learning. You don’t have to worry about bringing anything to class, except yourself!

Our seasoned instructors bring real-world experience to the classroom––your instructor has experience using VBA to solve challenges on the job, and will teach you how to do the same. In these interactive courses, you’ll complete targeted exercises for each and every new VBA concept that you learn. Our classes are small, so you’ll have time to ask questions and get personalized assistance from the instructor.

At the end of our Excel VBA courses, you’ll be able to automate tasks with complex macros and write efficient code designed to reduce errors. You’ll receive a course workbook you can use to recreate exercises and review reference material as needed after the course. You’re also entitled to a free retake of your VBA course within 6 months. 

VBA Classes in Manhattan, NYC

Our VBA 1 and 2 courses are designed for experienced Excel users that know their way around Pivot Tables and basic Excel formulas and functions. In just two days, you’ll learn enough VBA to use the program on your own. Both courses also feature a final lesson to help you troubleshoot common errors with code.

VBA 1 begins with an introduction to the VBA editor, while VBA 2 delves deeper into each topic, covering NESTED IF statements and user-defined functions. Many of the lessons in this course extend to other Microsoft programs that are compatible with VBA, including Word, Outlook, PowerPoint, and Access.

Enroll in VBA 1 and VBA 2 courses together and save 20% 

Not yet proficient in Excel? No problem! Our Excel courses offer training for everyone from complete beginners with no prior Excel experience to Excel power users that are ready to take their skills to the next level. 

  • Basic Excel users that haven’t experienced the power of Pivot Tables will get an intro to this feature in our Intermediate Class
  • For frequent Excel users that want to harness the application’s full potential, the Advanced Excel Class provides everything you need to know
  • Our Microsoft Excel Bootcamp combines the Beginner, Intermediate, and Advanced Classes for Excel users that really want to get ahead

All of our Excel courses are offered at our training facility in Midtown Manhattan. We travel within the Tri-state area, or for an additional travel fee, we can travel anywhere in the USA.

Corporate VBA Training and Professional Development

If your office relies on Microsoft Excel for daily tasks, learning Visual Basic for Applications is a great way to reduce errors and increase efficiency. We offer private classes and corporate training for small groups. Our courses are available on weekdays and weekends at our facility or yours. Contact us today for a free consultation.

Yelp Facebook LinkedIn YouTube Twitter Instagram