Excel Programming with VBA
Hands-on Training from Experts
NYC or Live Online
Excel VBA Classes in NYC
Choose another date
14 Hours
NYC or Live Online
VBA (Visual Basic for Applications) is the programming language used in Microsoft Excel. With VBA, you automate repetitive tasks in Excel.
In this hands-on class, you will learn the fundamentals of VBA programming by working on real-world applications of Macros and Excel automation. You’ll learn to automate repetitive operations, create custom commands, develop new worksheet functions, and more.
This course has a prerequisite
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
Highly Reviewed by Our Alumni
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Learn the Skills Guarantee™
Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.
Hands-on training
Work on projects proven to boost retention
Time-tested curriculum
Refined over many cohorts for an optimal learning experience
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Learn from experts
Experienced educators who are driven to help you succeed
Retake for free
Refresh the materials for free within one year
Interactive Training: Learn in Real-Time with Small Class Sizes
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects. Switch between live-online and in-person as needed, even after the course has started.
Unlike other providers, these are not mass open-enrollment classes. At Noble Desktop, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
On Campus in NYC 185 Madison Ave, NYC
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
- Live, interactive class
- Experienced instructor in the room with you
- Computer and software provided
Live Online Remote, from anywhere
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
- Live, interactive class
- Experienced instructor teaching over Zoom
- Remote setup assistance provided
Expert Instructors
Our instructors are verterans of their field and experienced educators, driven to help you succeed.
Earn a Certificate of Completion
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on 
Free Retake Within One Year
Refresh and solidify your understanding of the course content for no extra charge within a year, provided there is space in the class.
Excel Programming with VBA Curriculum
Courses in this Package
This is the recommended order, but some courses may be taken in a different order.
-
Unit 1 7 Hours
Excel VBA and Macros Level I
- Develop macros
- Perform calculations
- Create & format worksheets with macros
-
Unit 2 7 Hours
Excel VBA and Macros Level II
- Write scripts & work with variables
- Analyze data & create user interfaces
- Create automated event processes
What You’ll Learn at a Glance
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Create more complex macros
- Variables
- Looping statements
- Logic statements
- User Forms
- Error Trapping
- Troubleshooting
Project Examples
Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.
Frequently Asked Questions
-
Does this course require any prior knowledge or experience?
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.
-
Do you offer payment plans or student financing for this course?
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
-
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at hello@nobledesktop.com
-
What happens if I need to miss a session?
You have some options:
- You can watch a recording of the session. We will provide any course materials.
- If you can’t come into the classroom but can still attend remotely, we will provide you with the Zoom login information.
- You can use your free retake to make up any missed class time.
