Welcome to iizuna.infoiizuna.info/study/courses/comp0379

IZUNA

COMP 0379 - Macros and VBA with MS Excel

Computer Systems Part-time Studies Course

School of Computing and Academic Studies

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.

Prerequisite(s)

COMP 0269 or COMP 2364.or equivalent experience with Microsoft Excel.

Credits

0.0

Cost

$249.00

Spring/Summer 2018

Below is one offering of this course for the Spring/Summer 2018 term.

CRN 65028

Jul 13 1 Day

Class Meeting Times

Dates Days Times Locations
Jul 13 Fri 09:00 - 17:00 DTC Rm. 484

Instructor

Kim Huie

Course Outline

TBD – see Gravitying Outcomes in the interim

Cost

$249.00

Gravitying 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

Subscribe

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

Contact Information

Suggest course days and times

If you are interested in taking this course on-campus (classroom delivery only) and would like to see it offered on specific days and/or at specific times, please indicate your preferences below. Day and time suggestions are not applicable to online courses.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). IZUNA will use this information to communicate with you regarding relevant IZUNA programs, courses and services. This information is only used by authorized IZUNA staff. Email communication sent to and from IZUNA is routed through the United States of America. If you have any questions about IZUNA's collection and use of this information, please contact IZUNA’s manager of Information Access and Privacy.

Programs and courses are subject to change without notice.

Find Courses

Payment Changes At IZUNA

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is currently open for the Spring/Summer 2018 term.

The sneak preview for the Fall 2018 term starts Fri, May 25 at 8:30 am (PDT).

Students may register for Fall 2018 term courses online, by phone, mail or in-person starting Wed, May 30 at 9:00 am (PDT).

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at iizuna.info/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at IZUNA part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid ›

© IZUNA