Excel VBA Macros Level II

at NYC Career Centers - Midtown

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

Sun, Nov 17, 9:30am - 5:30pm

Next start dates (9)

Location:
Midtown, Manhattan
185 Madison Ave Ste 1104
At E 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

Microsoft Excel VBA Macros Level II Class Overview

Our Advanced Excel VBA Training will teach you to automate tasks, and streamline workflow, using Macros. Excel VBA Macros Level 2 is our advanced class, which assumes a familiarity with the basic Macro concepts, introduced in our Level 1 Excel VBA Class. An understanding of the skills taught in VBA Excel Classes will empower the user to utilize all of the tools taught, in our Excel courses, in the most efficient and powerful manner.

  • Free Retake: Retake the class for free once within six months (provided the class is running with an available seat).
  • Hands-on Training: Our intermediate Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own.
  • Computer Provided: We provide you with a computer with Excel so you can travel light

Upon successful completion of this course, students will be able to:

  • 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

Microsoft Excel VBA Macros Level II Class Outline

Lesson 1: VBA Editor

  • Project Explorer
  • Properties Window
  • Modules

Lesson 2: Creating / Editing Code

  • Functions
  • Events

Lesson 3: Invoking Macros

  • Worksheet Buttons
  • Customize Ribbon

Lesson 4: Compiling Code

  • Stepping through code
  • Setting Breakpoints

Lesson 5: Variables

  • Declarations
  • Option Compare Text
  • Option Compare Binary
  • Lifetime and Scope

Lesson 6: Working with The Object Model

  • Application
  • Workbook

Lesson 7: Creating & Naming Objects

  • Naming conventions
  • Housekeeping

Lesson 8: Navigation / Selection Techniques

  • Absolute versus Relative Reference
  • Offsets

Lesson 9: Logic Statements

  • Nested IF Statements
  • Case Statements

Lesson 10: Functions

  • Intrinsic Functions
  • User Defined Functions

Lesson 11: Looping Statements

  • For Each Next Loops

Lesson 12: Interactive Code

  • User Forms - dashboards
  • Message Boxes

Lesson 13: Error Handlers

  • Error numbers
  • Error descriptions

Still have questions? Ask the community.

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

(637 Reviews)
Excel VBA Macros Level II
Reviewed by Anonymous on 8/15/2016
Teacher was very knowledgeable and clear.
Excel VBA Macros Level II
Reviewed by parth p. on 8/22/2017
Excel VBA Macros Level II
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