Microsoft Excel Macros and VBA 3: Formulas and Functions COMP 9672


Microsoft Excel Macros and VBA 3: Formulas and Functions course teaches you cell addressing methods for the creation of unbreakable formulas. Start by learning to use key functions from each of Excel's function categories (including financial, date/time, math, statistical, lookup/reference, database, text, logical and information). Then acquire the VBA skills needed to create user-defined functions (UDF) so that standardized custom worksheet calculations can be easily inserted into worksheets. Also learn how to centralize the maintenance of VBA procedures and how to share or distribute them with users in a workgroup or over an entire organization. This online Excel course enables you to learn at your own pace while having an onscreen teacher lead you each step of the way. Better yet, live online help is available using desktop sharing, which makes the remote access experience feel like a live classroom. Once you have completed this course and its prerequisites, you can request a certificate of completion.


Course Delivery Method:

This is an online course, but it is not a Blackboard course. On the course start date, you will receive an email from (the teacher) containing the login information. The teacher will provide access information for the after-training support package (bonus material, updates, a searchable e-workbook and access to a Q&A forum) during the workshop.

Course Essentials:

You must have the Windows version of Microsoft Excel 2007 or higher.


You must have completed our COMP 9671 Microsoft Excel Macros and VBA 2: Data Analysis (Distance Learning) course. (An approved equivalent is also acceptable.) After you have registered for this workshop but before you begin class, you must complete the Before the Third Online Course materials.

Additional Information

This course and the other courses in the Microsoft Excel with Macros and VBA Program will not be offered again by Continuing Education at George Brown College after their July 13 offerings. Note that, if you are planning to complete the program, you will need to complete all three courses by August 2021. For more information, contact the Continuing Education Visual Arts and Design department co-ordinator.

Disclaimer: This course does not follow the standard Continuing Education refund policy, so note the following: Once you register, you will enjoy a trial access period that runs for seven days from the course start date (inclusive of the start date). During this trial period, you will have access to a limited set of resources. At the end of the trial, you must choose from two options: Continue to Full Access Training or Request a Refund. (Refunds are the full course fee less an administrative fee.) At this time, refunds for withdrawals can only be made by cheque, regardless of your method of payment, if you choose not to continue to the full access training. Ensure that your online student account contains your current address, and allow four weeks for processing and mail delivery of refund cheques. If you ask to have a duplicate cheque printed, you will be charged an administrative fee.

Hours and Fees




(includes an after-training support package of bonus material, updates, a searchable e-workbook and access to a Q&A forum)

Course Sections

Delivery Method: Online
Delivery Method: Online

Contact Information


416-415-5000, ext. 2013

Some courses require you to purchase a textbook. The cost of the textbook is not included in the course fee unless otherwise indicated. If there is a textbook assigned for this course, it will be listed on the bookstore website.