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 Excels What-If analysis tools. Students also learn many of Excels 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 Dec 16 / 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:
MO-INFO10079
Host college code:
LO-COMP8167
How to register
Register online by visiting the Continuing Education Registration platform
If you require assistance please visit our How to Register webpage. When Registering for a course, it is not necessary to include the 2 digit college code prefix (e.g. ENL001– not DU-ENL001).
Contact
Karen Bacher
OntarioLearn Coordinator, Continuing Education
Email : karen.bacher@mohawkcollege.ca
135 Fennell Avenue WestHamilton, ON
L9C 0E5
Phone : (905) 575-2706
Fax :