Excel VBA Macros Level 2

at NYC Career Centers - Midtown

(686)
Course Details
Price:
$345 10 seats left
Start Date:

Sat, Dec 19, 9:00am - 5:00pm Eastern Time

Next start dates (2)

Location:
Midtown, Manhattan
185 Madison Ave 3rd Floor
At E 34th St
New York, New York 10016
(Map)
Purchase Options
Description
Class Level: Intermediate
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:

Dive into advanced VBA and Excel functions in Excel VBA and Macros Level II. This course builds upon lessons learned in Excel VBA and Macros Level I, including creating objects, loops, and logic statements. Learn how to control variables and create automated processes.

Master Advanced Excel Functions with VBA
In Excel VBA and Macros Level II, you will create a user interface to input data. In addition, learn how to evaluate data with looping structures and logic statements. As with Level I, Excel VBA and Macros Level II ends with a lesson on Error Handling, in which you'll review error numbers and descriptions.

Enroll in VBA Bootcamp and Save
Are you an experienced Excel user that is new to VBA? Save 20% off when you enroll in the Excel VBA and Macros Bootcamp. The bootcamp includes Excel VBA and Macros Levels I and II. This two-day, 14-hour course covers Level I on the first day of bootcamp, and Level II on the second day.

This course has a prerequisite
Excel VBA and Macros Level I or knowledge equivalent.

Course Overview

  • 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 (3)
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm Eastern Time TBD 1 $345
9:00am - 5:00pm Eastern Time TBD 1 $345
9:00am - 5:00pm Eastern Time TBD 1 $345

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 3450 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (1)

Get quick answers from CourseHorse and past students.

Question from alex l.
Is this class available during the weekend like the VBA Level 1?
Answer from Billy C. CourseHorse StaffCourseHorse Staff
Unfortunately, this lesson isn't available during the weekends.
Answer
Cancel

Reviews of Classes at NYC Career Centers (671)

(671 Reviews)
Excel VBA Macros Level 2
Reviewed by Anonymous on 8/15/2016
Teacher was very knowledgeable and clear.
Excel VBA Macros Level 2
Reviewed by parth p. on 8/22/2017
Excel VBA Macros Level 2
Reviewed by indre s. on 3/10/2015
loading...
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