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

Visual Basic for Applications (VBA) is the programming language used with Excel and all other Microsoft Office programs. Graduates of this course will be able to perform basic programming using Excel VBA.

With the skills and knowledge gained in this course, you will be able to explain the use of the Excel interface to create modules, subroutines, and custom functions. You will be able to determine when to use the macro recorder or the VBA Editor to create and modify macros to automate routine tasks. You will also be able to work with various control structures and identify variables, arrays, and error handling.

You do not need any previous programming background to take this course, although prior to enrolling in this course completion of CCTO340 Microsoft Excel Level III is recommended.

View Course Outline

Upcoming Offerings

Delivery Methods

  • Face to Face: Where: In-person meetings. When: Course is scheduled at a specific time for students to attend. Face-to-face instruction at all class meetings. Location may be on campus or at a worksite.
  • Blended: Where: Mixture of in-person & online components. When: Course is scheduled at a specific time for students to attend. Combination of face-to-face and online components at specific times. Some online components may be accessed online anytime.
  • Hyflex: Where: Choice to attend in-person or online meetings. When: Course is scheduled at a specific time for students to attend. For each class, students choose to attend in-person with the instructor or online at a specific time.
  • Remote Live Delivery: Where: Online with instructor. When: Course is scheduled at a specific time for students to attend. Instruction is delivered at set times online. Students do not come to campus.
  • Remote On-Demand Delivery: Where: Online anytime. When: No set class meetings. Coursework is accessed on-demand and online. While there are no set class meetings, there may be set due dates and deadlines for some activities. Students may interact with peers through virtual tools.
  • Remote Independent: Where: Online anytime. When: No set class meetings. Coursework is accessed on-demand and online, with no instructor support. While students choose when to do coursework, there may be set due dates and deadlines. 
  • Work Placement: Where: In-person meetings. When: Work is scheduled at a specific time for students to attend. Onsite work integrated learning. Location at a worksite.
Shopping Cart Quick View
Open Shopping Cart