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:
NC-COMP1909

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. ENL 001–not NC-ENL001). For details visit https://www.niagaracollege.ca/parttimestudies/registration/ .

Contact

Bill Groves
Phone : (905) 735-2211 ext. 7606
Email : distance@niagaracollege.ca

100 Niagara College Boulevard
Welland, ON
L3C 7L3

Phone : (905) 735-2211
Fax : (905) 736-6010

Find on map

Go to the Website