Discover Classes. Earn Rewards.

Excel VBA and Macros Level I

Master the art of automating Excel with VBA macros in this beginner-friendly course. Learn how to enhance your spreadsheet skills and boost productivity by incorporating basic macros. No prior programming knowledge is required, just a basic understanding of Excel functions.

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

Start Dates (5)

  • $345
  • Noble Desktop @ 185 Madison Ave 3rd Floor, 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 visual basic training:

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.

This course has a Prerequisite: 

  • Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, Pivot Tables, and IF statements.

Learn more about Excel VBA and Macros Level I at Noble Desktop.

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 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]"

Reviews of Classes at Noble Desktop (372)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Noble Desktop

Noble Desktop

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

Reviews of Noble Desktop at coursehorse.com

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