Discover Classes. Earn Rewards.

Excel Programming with VBA

Unlock the full potential of Excel with VBA programming. Learn how to automate tasks, eliminate errors, and accelerate your workflow in this hands-on course. Take your Excel skills to the next level at NYC Career Centers.

  • All levels
  • 18 and older
  • $549
  • 185 Madison Ave, New York, NY & Virtually Online
  • 14 hours over 2 sessions
Excel Programming with VBA

Start Dates (5)

  • $549
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
  • 14 hours over 2 sessions
20 seats left
Book
Show all 2 sessions
  • Mon, Apr 15 at 10:00am - 5:00pm
  • Tue, Apr 16 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Sun, May 12 at 10:00am - 5:00pm
  • Sun, May 19 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Mon, Jun 24 at 10:00am - 5:00pm
  • Tue, Jun 25 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Thu, Aug 22 at 10:00am - 5:00pm
  • Fri, Aug 23 at 10:00am - 5:00pm
20 seats left
Book
Show all 2 sessions
  • Wed, Nov 20 at 10:00am - 5:00pm
  • Thu, Nov 21 at 10:00am - 5:00pm
Showing 15 of 5

Class Description

Description

What you'll learn in this excel class:

Master VBA (Visual Basic for Applications) and macros in this course for avid Excel users. Visual Basic for Applications or VBA is Microsoft's coding language to program Excel. You can use it to write macros and automate tasks. On Day 1, you'll learn everything covered in Excel VBA Macros Level 1. Day 2 covers advanced VBA techniques in Excel VBA Macros Level 2.

In this hands-on course, you'll learn how to accelerate your workflow in Excel with macros. In addition to working faster, you'll also work smarter by eliminating possible errors — both days of the course end with a lesson on error handling with VBA code.

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.

Course Overview

  • Develop a macro
  • Format worksheets using macros
  • Create an interactive worksheet
  • Work with multiple worksheets
  • Perform calculations
  • Navigate a workbook using offsets, range names, and variables
  • Analyze data using looping structures, in combination with if and case statements
  • Create user interface structures to capture multiple variable inputs
  • Control the lifetime and scope of variables
  • Create automated event processes
  • Create automation to handle unforeseen errors and events

Please click HERE for the Course Syllabus


Learn more about Excel Programming with VBA at NYC Career Centers

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYC Career Centers (680)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYC Career Centers

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...