• Microsoft Excel (Macros and VBA) II - Data Analysis COMP 9671

    Online Workshop

    Our Microsoft Excel (Macros and VBA) II - Data Analysis course teaches you to analyze data using Excel's analytical tools, including data consolidation, data filter, data subtotals, pivot tables and charting techniques. Explore best practice for Excel data structures so that these tools operate as intended, and develop the skills you need to create macros to enhance their usefulness. Learn to easily produce the required analysis at the push of a button. 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.


    This is an online course. Please ensure you are familiar with the basic technology requirements for online courses. The course fee includes all taxes and an after-training support package that contains bonus material, updates, a searchable e-workbook and access to a Q&A forum. (The teacher will provide access information for these resources during the workshop.) However, this course does not follow the standard Continuing Education refund policy, so please 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 can only be made by cheque, regardless of your method of payment. 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.


    You must have completed our COMP 9670 Microsoft Excel (Macros and VBA) I - Data Input course or an approved equivalent. After you have registered for this workshop but before you begin class, you must complete the Before the Second Online Course materials.

    Contact Information

    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.