Discover Classes. Earn Rewards.

Excel Programming with VBA

at NYC Career Centers - Midtown

(683)
Course Details
Price:
$549 8 seats left
Start Date:

Thu, Sep 24, 9:00am - Sep 25, 5:00pm Eastern Time (2 sessions)

Next start dates (5)

Location:
Midtown, Manhattan
185 Madison Ave 3rd Floor
At E 34th St
New York, New York 10016
(Map)
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 7

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

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


Still have questions? Ask the community.

Refund Policy

Note: This provider has a temporary cancellation policy for COVID-19 related cancellations which is as follows: 

We are allowing attendees to reschedule at no charge or keep class credit for up to two years. Email us at [email protected] 

---- 

Original cancellation policy (non-COVID-19):

  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

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.

Start Dates (6)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Fri, Sep 25 9:00am - 5:00pm Eastern Time TBD
9:30am - 5:30pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Sun, Oct 18 9:30am - 5:30pm Eastern Time TBD
9:00am - 5:00pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Thu, Oct 22 9:00am - 5:00pm Eastern Time TBD
9:00am - 5:00pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 17 9:00am - 5:00pm Eastern Time TBD
9:00am - 5:00pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Sat, Dec 19 9:00am - 5:00pm Eastern Time TBD
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Eastern Time TBD 2 $549
This course consists of multiple sessions, view schedule for sessions.
Wed, Dec 23 9:00am - 5:00pm Eastern Time TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 5490 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NYC Career Centers (668)

Similar Classes

School: NYC Career Centers

NYC Career Centers

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...

Read more about NYC Career Centers

CourseHorse Approved

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

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here
Loading...