Skip to main content

Macros and VBA with MS Excel COMP 0379

Computer Systems Course

Course details

​This intensive hands-on seminar builds on top of COMP 0269 or COMP 2364. Those with prior knowledge of MS Excel are shown how to increase productivity by creating macros to automate routine procedures. Students work through a variety of real-life examples to acquire the skills to create and modify macro procedures. Exercises include how to standardize document formats, many times without having to write a single line of code. Topics include: examining tools on the Developer tab, creating custom command buttons to execute macro code, and macro security. Reviewing the VBA Editor window to edit basic procedures using VBA (Visual Basic for Applications) is also discussed. Upon completion of COMP 0379 successful students will be able to create macros to control MS Excel and to save time on repetitive tasks. COMP 0379 will be offered in the Spring (April) term​ or Fall (September) term.​​

Prerequisite(s)

Credits

0.0

Cost

$247.16 - $252.92 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2023

Below is one offering of COMP 0379 for the Spring/Summer 2023 term.

CRN 65028

Duration

Fri Jul 14 (1 day)

  • 1 day
  • CRN 65028
  • $247.16
Class meeting times
Dates Days Times Locations
Jul 14 Fri 09:00 - 17:00 Online
Instructor

Kim Huie

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$247.16

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. Course is 7 hours synchronous online class. As this is a one-day workshop and will move quickly in order to cover all of the material, it is important that the student is prepared. Please understand that it is the student’s responsibility to be prepared; to have the prerequisites, hardware and technology required to login and participate. Students must provide their own PC or laptop with Windows 10 or 11 and Excel 2021 or Microsoft 365 in order to participate in this course successfully.
Status

Fall 2023

Below is one offering of COMP 0379 for the Fall 2023 term.

CRN 44605

Duration

Fri Dec 08 (1 day)

  • 1 day
  • CRN 44605
  • $252.92
Class meeting times
Dates Days Times Locations
Dec 08 Fri 09:00 - 17:00 Online
Instructor

Kim Huie

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$252.92

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. Course is 7 hours synchronous online class. As this is a one-day workshop and will move quickly in order to cover all of the material, it is important that the student is prepared. Please understand that it is the student’s responsibility to be prepared; to have the prerequisites, hardware and technology required to login and participate. Students must provide their own PC or laptop with Windows 10 or 11 and Excel 2021 or Microsoft 365 in order to participate in this course successfully.
Status

Learning Outcomes

Upon successful completion of the course, the student will be able to:

  • Display the Developer tab.
  • Identify and use the Code tools on the Developer tab.
  • Use the Macro Recorder to create macros in MS Excel.
  • Understand the difference between Relative vs Absolute recording.
  • Execute macro functions using shortcut keys.
  • Save macros in the current workbook, new workbook or Personal Macro Workbook.
  • Create command buttons, attach and execute macros through buttons.
  • Understand macro security in workbooks and to enable trusted locations.
  • Customize the Ribbon by adding macro procedures onto the Ribbon and onto the Quick Access Toolbar.
  • Access the VBA Editor window and examine the VBA code written behind macros.
  • Edit basic macro code in the VBA Editor window.
  • Write basic VBA procedures.
  • Use built-in VBA functions.

Effective as of Spring/Summer 2017

Contact Us

If you have a question or comment about this course, please complete and submit the form below.

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of Macros and VBA with MS Excel (COMP 0379)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.