OL 803
Online LearningExcel - 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.
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.