Excel: Expert COMP 9669

Online
OntarioLearn

OntarioLearn description: This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course Excel Core. Students will learn how to create and analyze spreadsheets using PivotTables and Pivot Charts, 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-2019).

Note(s)

Course Delivery Method:

This is an OntarioLearn online course delivered via the OntarioLearn Portal. Teacher support will be available via email, and technical support will be available via phone.

Course Essentials:

You must have Microsoft Excel 2016, 2019 or 365 for Windows. (You will not be able to complete the course with any other version of Excel or with Excel running on a Macintosh. Macintosh systems are not supported in this course.)

Prerequisites

You must be familiar with Windows and file management concepts, and you must have completed COMP 9668 Excel: Core (Distance Learning). (An approved equivalent is also acceptable.)

Hours and Fees

Hours

42

Fee

$433

Course Sections

CRN:
S84754
Delivery Method: Self-directed Online
Contact:
OntarioLearn Department
Phone:
Location(s):

Read about our textbooks policy, and remember that the Continuing Education attendance policy and closure dates differ from those for full-time college programs.