Discover Classes. Earn 10% Rewards.

Excel VBA and Macros Level II

Build advanced Excel VBA and macros in our Level II course, stepping into topics like VBA Editor, code writing, macro invocation, and error handling. Lift your automation skills and streamline workflows efficiently with interactive code and logic statements. Tap into the full potential of Excel through our comprehensive training, building on foundational knowledge from our Level I class.

  • All levels
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online
  • 7 hours

Express Checkout – $345


Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (7) $345/person

20 left
Book
20 left
Book
20 left
Book
20 left
Book
20 left
Book
Showing 1 – 5 of 7

Book a Private 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.

Class Description

Description

Master the fundamentals of VBA programming and macro development through this practical and comprehensive training course. The curriculum covers essential topics including the VBA Editor environment, writing and editing functional code, invoking and testing macros, working with objects and their properties, implementing logic statements and control structures, building and using custom functions, creating loops for repetitive tasks, developing interactive code that responds to user input, and implementing comprehensive error handling strategies to ensure robust applications and reliable results.

Our Advanced Excel VBA Training goes beyond the basics to teach you how to automate routine tasks and streamline your workflow using powerful macros and custom functions. Excel VBA Macros Level 2 builds upon foundational concepts introduced in our Level 1 course and is designed for students with basic macro knowledge. Developing proficiency in the skills taught across these VBA courses will empower you to leverage all the advanced tools covered in our broader Excel curriculum with maximum efficiency and effectiveness.

Course Prerequisites:

Students should have a solid grasp of the concepts covered in Excel VBA and Macros Level I.

Maximize Your Training Investment:

Consider upgrading to our comprehensive Excel Programming with VBA package to save significantly on your total training costs and access premium resources.

For additional information, visit our detailed course page for Excel VBA and Macros Level II at Noble Desktop.

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

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Noble Desktop (452)

Similar Classes

Noble Desktop

Noble Desktop is a reputable New York-based training institute known for offering a wide range of creative and technical courses, including web development, design, coding, and digital marketing. With a strong emphasis on hands-on learning and industry-relevant skills, Noble Desktop equips individuals with the knowledge and expertise needed to excel in today's competitive job market.

View school profile
Noble Desktop
Vetted by CourseHorse

A verified Brooklyn educator.

CourseHorse’s Choice 4.6 out of 5 · 452 reviews
Loading...