Discover Classes. Earn Rewards.

Excel VBA Macros Level I

at NYC Career Centers - Midtown

(617)
Course Details
Price:
$345 8 seats left
Start Date:

Thu, Jul 11, 9:00am - 5:00pm

Next start dates (5)

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 I Class Overview

Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is a basic VBA (Visual Basic for Applications) class, that will help you apply spreadsheet skills, in a faster, more efficient and exciting way.

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

  • develop a macro
  • format worksheets using macros
  • create an interactive worksheet
  • work with multiple worksheets
  • perform calculations

Microsoft Excel VBA Macros Level I Class Outline

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

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

Get quick answers from CourseHorse and past students.

Reviews of Classes at NYC Career Centers (599)

(599 Reviews)
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
Reviewed by Anonymous on 4/17/2015
Excellent instructor. Good curriculum. I feel much more confident now. .
Excel VBA Macros Level I
Reviewed by Anonymous 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 Raymond D. on 6/20/2019
Excel VBA Macros Level I
Reviewed by Elyse D. on 4/30/2019
loading...
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
Taking this class for work? Get exclusive perks & discounts for free.
Loading...