Microsoft Excel Macros and VBA 1: Data Input COMP 9670 Online Workshop Email to a Friend Our Microsoft Excel Macros and VBA 1: Data Input course teaches you to use Excel features and create Excel macros so that you end the course having created a database update application. As a result, you'll have learned to create Excel macros from the ground up. Learn to generate unbreakable VBA code and to use absolute referencing, relative referencing and VBA Messaging to control or abort macro processing. Focus on the use of Excel's Macro Recorder to minimize the need for manual VBA coding. 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) Course Delivery Method: This is an online course, but it is not a Blackboard course. Make sure you are familiar with the basic technology requirements for non-Blackboard online courses (under "Other online courses"). On the course start date, you will receive an email from email@example.com (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 will be required to have your own Microsoft Excel software. It must be the Windows version and must be Excel 2007 or higher. 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. Prerequisite(s) Macro/VBA experience is not required. However, you must have completed our COMP 9197 Microsoft Excel 1 course or our COMP 9334 Computer Basics and Microsoft Office 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 First Online Course materials. Contact Information 416-415-5000, ext. 2013 firstname.lastname@example.org Course Section(s) Available CRN: S83222 Date(s) 14 May 2019 – 10 Jun 2019 Teacher: Dennis Plum Hours: 7 Fee: $350 (includes an after-training support package that includes bonus material, updates, a searchable e-workbook and access to a Q&A forum) Note: Registration deadline: 11:59pm on May 13, 2019 CRN is Closed CRN: S83223 Date(s) 11 Jun 2019 – 08 Jul 2019 Teacher: Dennis Plum Hours: 7 Fee: $350 (includes an after-training support package that includes bonus material, updates, a searchable e-workbook and access to a Q&A forum) Note: Registration deadline: 11:59pm on June 10, 2019 Register Now CRN: S83224 Date(s) 09 Jul 2019 – 05 Aug 2019 Teacher: Dennis Plum Hours: 7 Fee: $350 (includes an after-training support package that includes bonus material, updates, a searchable e-workbook and access to a Q&A forum) Note: Registration deadline: 11:59pm on July 8, 2019 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.