Return to Excel Classes

VBA Classes

VBA Classes

excel class scheduleAugust 5th, 12th 9am
August 15th, 22nd 10am
September 5th, 6th 10am

Corporate Groups
4 or more people:
Contact Us to schedule private dates and times
Price: $549
excel class registration

Course Outline

download the pdfDownload the PDF

  1. Lesson 1: VBA Terminology
  2. Lesson 2: Macros
    1. Strengths
    2. Weaknesses
  3. Lesson 3: Debug Macros
    1. Variable Substitution
    2. Variable Concatenation
  4. Lesson 4: Variables
  5. Lesson 5: VBA Basics
    1. Navigate Cells
    2. Read And Write To Cells
    3. Navigate Worksheets
      1. Add Worksheets
      2. Name Sheets
      3. Hide Sheets
  6. Lesson 6: Programming Control Structures
    1. Loops
      1. For Next
    2. Decision Control
      1. If Then Else
  7. Lesson 7: Error Handling
  8. Lesson 8: Speed Up Code
  9. Lesson 9: Functions
  10. Lesson 10: Workbook Events
  11. Lesson 11: Loops
    1. Do While And Do Until
    2. For Each

Contact Us

Name
Phone or Email
Question(s)



FAQ

faqWhere are you located?
Our address is 225 West 34th Street between 7th and 8th Avenue.

What time does class start?
Most weekday classes begin at 9am. Most weekend classes begin at 10am.

What topics are covered?
Each class provides an outline, please consult the class page for details.

Do you offer retakes?
Yes! The only class that offers unlimited retakes (time and quantity).

Do I need to bring a computer?
We provide a computer, an illustrated book, pens and snacks.

Do you provide a certificate
Yes! Your gold foil certificate will stand out on your cubicle wall.

Summary
Event
VBA Classes
Location
VBA Class, 225 West 34th Street,New York City,NY-10122
Starting on
August 5, 2019
Ending on
August 12, 2019
Description
Learn Excel VBA programming, variables, loops, decision making with macros. Beginner to intermediate programming class.
Offer Price