Discover Classes. Earn Rewards.

Excel VBA Macros Level 2

Take your Excel VBA skills to the next level with advanced functions and automation techniques in this advanced course. Master user interface creation, data analysis, and error handling. Prerequisite: Excel VBA and Macros Level I or equivalent knowledge.

  • Intermediate
  • 18 and older
  • $345
  • 185 Madison Ave, New York, NY & Virtually Online
  • 7 hours

Start Dates (5)

  • $345
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
  • 7 hours
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Showing 15 of 5

Class Description

Description

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

Syllabus

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

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)

(4.5-star rating across 680 reviews)
  • Excel VBA Macros Level 2

    Anonymous review 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
See reviews for other classes at NYC Career Centers
loading...
Hide Reviews

Review Summary by CourseHorse

Students who took the Excel VBA Macros Level 2 class praised the teacher for being knowledgeable and clear. They were able to learn a lot of valuable information and skills in this class. Some of the specific concepts they learned include advanced techniques for using VBA macros, creating and editing user forms, and automating complex tasks in Excel. Quote: 1. "I learned how to streamline my spreadsheet processes and save a lot of time by automating tasks with VBA macros."

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 Show answer
Cancel

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