Discover Classes. Earn Rewards.

Excel VBA Macros Level I

Learn how to streamline your Excel tasks and increase your productivity with the Excel VBA Macros Level I course at NYC Career Centers. Master the art of macros and automation, and gain hands-on experience in writing code and creating macros. Take your Excel skills to the next level with this comprehensive course.

  • 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:

Learn macros and automation in Excel VBA and Macros Level I. The class begins with an introduction to Visual Basic for Applications (VBA) and macros. Throughout the course, you'll learn hotkeys, how to compile code, loops, and logic statements. The session ends with a lesson on using interactive code to create input and message boxes, and error handling, so you can avoid mistakes that lead to software crashes.

Excel VBA Programming Course Workbook
Our hands-on training approach helps to reinforce content, so you'll remember not just what you learned, but how to do it. By the end of Excel VBA and Macros Level I, you'll have experience writing code and creating macros. You'll also receive a personal copy of the course workbook, where you can take detailed notes to help you replicate the practice activities at home. The course workbook is a valuable training and reference tool that you can take on the job or anywhere you go for work.

This course has a prerequisite
Fundamental Excel knowledge equivalent to our Beginner Microsoft Excel course.

Course Overview

  • Develop a macro
  • Format worksheets using macros
  • Create an interactive worksheet
  • Work with multiple worksheets
  • Perform calculations

Please click HERE for the Course Syllabus

Syllabus

Lesson 1: Macros / VBA

  • What are Macros?
  • What is VBA?
  • How to record macros
  • How to run macros

Lesson 2: VBA Editor

  • Modules
  • Procedures
  • Project Explorer
  • Toolbars / Options

Lesson 3: Creating / Editing Code

  • Create Procedures
  • Subs
  • Comments

Lesson 4: Invoking Macros

  • Hot Keys
  • Quick Access Toolbar
  • Call Command

Lesson 5: Compiling Code

  • Stepping through code
  • Reset
  • Run

Lesson 6: Variables

  • Declarations
  • Option Explicit
  • Data Types

Lesson 7: Working with The Object Model

  • Worksheets
  • Ranges: Rows, Columns, Cells

Lesson 8: Creating & Naming Objects

  • Naming conventions
  • Housekeeping

Lesson 9: Navigation / Selection Techniques

  • Formula R1C1 Reference Style
  • Offsets
  • Range Names

Lesson 10: Logic Statements

  • IF Statements

Lesson 11: Looping Statements

  • Do Loops

Lesson 12: Interactive Code

  • Input boxes
  • Message boxes

Lesson 13: Error Handlers

  • Preventing fatal errors and crashes

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 (679)

(4.5-star rating across 679 reviews)
  • Excel VBA Macros Level I

    Reviewed by Dahiana C. on 11/27/2019
    very good
  • Excel VBA Macros Level I

    Anonymous review on 8/23/2019
    The instructor Garfield was really good. The course material was also good, and covered enough contents.
  • Excel VBA Macros Level I

    Reviewed by alex l. on 2/4/2018
    Pete does it again. Very good instructor who sets a good pace with his lessons. Unfortunately some classmates weren't up to my speed and slowed down the class. If they had a one on one availability i would definitely consider it, even with the exponential increase in cost it would likely involve, but that's just me.
  • Excel VBA Macros Level I

    Anonymous review on 4/17/2015
    Excellent instructor. Good curriculum. I feel much more confident now. .
  • Excel VBA Macros Level I

    Anonymous review on 10/1/2014
    This was an excellent class. Pete the instructor had his own home grown project instead of using the microsoft materials which many times are more product focused than usefful. We were not able to get through all the material so hopefully I can take it again when I have time. It was an excellent intro and since none of us have programming work experience it was paced perfectly.
  • Excel VBA Macros Level I

    Reviewed by Shelley H. on 1/26/2020
  • Excel VBA Macros Level I

    Reviewed by Raymond D. on 6/20/2019
  • Excel VBA Macros Level I

    Reviewed by Elyse D. on 4/30/2019
  • Excel VBA Macros Level I

    Reviewed by Sulthana S. on 9/10/2017
  • Excel VBA Macros Level I

    Reviewed by Broni L. on 9/28/2016
  • Excel VBA Macros Level I

    Reviewed by Hai-Fen L. on 3/7/2016
  • Excel VBA Macros Level I

    Anonymous review on 5/29/2015
See reviews for other classes at NYC Career Centers
loading...
Hide Reviews

Review Summary by CourseHorse

Students who have taken the Excel VBA Macros Level I class have expressed positive feedback about their experience. They praised the instructor, Garfield, for his teaching skills and the course material for covering a sufficient amount of content. Some students mentioned that the pace of the lessons set by the instructor, Pete, was good. Students mentioned that they felt more confident after completing the course and appreciated Pete's own project-based approach instead of relying solely on Microsoft materials. Furthermore, many expressed their desire to retake the class in order to cover all the material thoroughly. Quotes: 1. "The course material was also good, and covered enough contents." 2. "Pete the instructor had his own home grown project instead of using the Microsoft materials which many times are more product focused than useful." 3. "Since none of us have programming work experience it was paced perfectly."

Questions & Answers (1)

Get quick answers from CourseHorse and past students.

Question from Preston F.
How are the lessons broken out? Only the start dates are listed, but a calendar for when each of the lessons takes place would be nice.
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Preston! This is a one-day course, hence all the lessons listed on the course description will be discussed during the one-day class. Hope this helps.
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...