Excel Expert

Course Information

This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course COMP8166 (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).

Intake

Start Date

End Date Oct 08 / 2025

Prerequisite(s):

LO-COMP8166 Excel Core or equivalent

Computer Software Requirements:

Microsoft Excel 2019, 2021, or 365. MAC Users will not be supported in this course.

Chats:

No

Group Work:

No

Registering college code:
LO-COMP8167

Host college code:
LO-COMP8167

How to register

You can register in-person, on-line, by phone, fax or mail.  When registering for a course, it is not necessary to include the 2 digit college code prefix (e.g. ENL001– not LO-ENL001).

Contact

Distance Education
Phone : 1-888-569-2547
Email : distance@loyalistcollege.com

P.O. Box 4200
Wallbridge-Loyalist Road
Belleville, ON
K8N 5B9

Phone : 1-888-569-2547
Fax :

Find on map

Go to the Website