Microsoft Excel (Macros and VBA) III - Formulas and Functions COMP 9672 Online Workshop Email to a Friend Our Microsoft Excel (Macros and VBA) III - 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. Note(s) The course fee includes all taxes and an after-training support package, which contains bonus material and updates, a searchable e-workbook and access to a Q&A forum (the teacher will provide access information for these resources during the workshop). This is an online course. Please ensure you are familiar with the basic technology requirements for online courses. You will also be required to provide your own Microsoft Excel software (2007 or higher). Once you have completed this course and its prerequisites, you can request a Record of Achievement. Prerequisite(s) You must have completed our COMP 9671 Microsoft Excel (Macros and VBA) II - Data Analysis course or an approved equivalent. After you have registered for this workshop but before you begin class, you must complete the Before the Third Online Course materials. Contact Information 416-415-5000, ext. 2013 firstname.lastname@example.org Course Section(s) Available CRN: W52498 Date(s) 14 Mar 2017 – 10 Apr 2017 Hours: 6.5 Fee: $350 Note: Registration deadline: March 13, 2017 CRN is Closed CRN: S83156 Date(s) 09 May 2017 – 05 Jun 2017 Hours: 6.5 Fee: $350 Note: Registration deadline: May 8, 2017 Register Now CRN: S83157 Date(s) 06 Jun 2017 – 03 Jul 2017 Hours: 6.5 Fee: $350 Note: Registration deadline: June 5, 2017 Register Now CRN: S83158 Date(s) 04 Jul 2017 – 31 Jul 2017 Hours: 6.5 Fee: $350 Note: Registration deadline: July 3, 2017 Register Now 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.