OL 803

Online Learning

Excel - Expert

This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course OL702 Excel Core. Students will learn how to create and analyze spreadsheets using PivotTables and PivotCharts, and Excel’s What-If analysis tools. Students also learn many of Excel’s advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create their own custom functions. In addition, students learn how to protect and share their workbooks. This course helps prepare students wishing to pursue the MOS certification exams for Excel Expert (Excel Expert 2016 exam 77-728 and Excel Expert 2019 exam MO-201). Computer Software Requirements: MS Excel version 2016, 2019, 2021 or 365 for windows. MAC users are not supported in this course.

Computers
Sign Up

Registration

Upcoming Sessions

Browse the available offerings below and register for the session that fits your schedule.

  • OnlineClosed

    MAY 12-AUG 18

    Reference number
    CRN 30715
    Course fee$401.86

    Registration closed

  • OnlineClosed

    JUL 02-OCT 08

    Reference number
    CRN 30297
    Course fee$401.86

    Registration closed

  • OnlineOpen

    SEP 08-DEC 15

    Reference number
    CRN 11553
    Course fee$401.86
    Register
  • OnlineOpen

    NOV 02-FEB 08

    Reference number
    CRN 11132
    Course fee$401.86
    Register

Online Learning

How this course is delivered

This course is delivered fully online through OntarioLearn, a partnership of Ontario colleges — study from anywhere with an internet connection, on a schedule that fits around work and family.

  • Learn Anytime

    No live lectures — course content is available 24/7.

  • Weekly Structure

    Follow a weekly course schedule with set tasks.

  • Multimedia Content

    Learn through modules, videos, forums, assignments, and quizzes.

  • Instructor Support

    Facilitators are available to answer questions and provide feedback.

  • Independent Learning

    It’s self-study — be ready to push yourself and stay on track.

  • Time Commitment

    Expect around 5–12 hours per week, depending on your familiarity with the subject.