Welcome to the new NAIT.ca! We encourage you to explore the site and provide your feedback.

Continuing Education

CCTO445 - Introduction to Excel VBA

Course Code

A unique identifier used at NAIT for this specific course.

Campus

The location where your NAIT courses will be held.

Course Overview

Introduction to Excel VBA teaches students the basics of programming in Excel VBA. Students will begin their programming journey by using the macro recorder to record macros and the Visual Basic Editor to modify the macros. Students will learn about the Excel interface and to create modules, subroutines and custom functions. The focus of the course will be to work with control structures such as the If Then Else statement, If-Elseif, and Select Case. Students will also learn how to work with For Next, Do While, and Do Until Loops. Functions such as MsgBox, InputBox, UCase, CInt, and others will be incorporated into the code. Creating various types of variables and arrays and trapping and handling errors will also be discussed. This course assumes you have no programming background.

Recommended: CCTO340 Microsoft Excel Level III

Upcoming Offerings

Filter by Terms:
Section Start/End Schedule
A01 Aug. 01 - Aug. 02, 2019 Thu, Fri
Hours Delivery Fees
14 hours Day $450
Meeting Times:
  • Aug. 1 & 2 - Thursday, Friday: 8:00 AM - 3:50 PM

Section Start/End Schedule
A01 Nov. 20 - Nov. 21, 2019 Wed, Thu
Hours Delivery Fees
14 hours Day $450
Meeting Times:
  • Nov. 20 & 21 - Wednesday, Thursday: 8:00 AM - 3:50 PM

Section Start/End Schedule
E01 Jan. 10 - Jan. 12, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $450
Meeting Times:
  • Jan. 10 - Friday: 6:00 PM - 9:50 PM
  • Jan. 11 - Saturday: 8:00 AM - 3:50 PM
  • Jan. 12 - Sunday: 8:00 AM - 11:50 AM

Section Start/End Schedule
E01 May. 01 - May. 03, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $450
Meeting Times:
  • May. 1 - Friday: 6:00 PM - 9:50 PM
  • May. 2 - Saturday: 8:00 AM - 3:50 PM
  • May. 3 - Sunday: 8:00 AM - 11:50 AM

*Day delivery ranges between 8 AM - 5 PM.
**Evening delivery ranges between 5 PM - 10 PM.