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:
CG-OLRN1303

Host college code:
LO-COMP8167

How to register

Registration is completed online via the Student Portal. When registering for a course, it is not necessary to include the 2-digit college code prefix (e.g. OLRN1715, not CG-OLRN1715). For more information, visit https://continuing-education.conestogac.on.ca/ontario-learn.

Contact

Conestoga College
Email : OntarioLearn@conestogac.on.ca

299 Doon Valley Drive
Kitchener, ON
N2G 4M4

Phone : xxx
Fax :

Find on map

Go to the Website