Return to Excel Classes

VBA Classes

VBA Classes

excel class scheduleJune 23rd-24th 9am
July 11th, 18th 10am
July 14th-15th 9am

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.