OntarioLearn Course Details Start at 11/01/2024
To register for an OntarioLearn course visit the Continuing Education website.
Course Details
Course Title |
Excel Expert |
Conestoga Course Code |
OLRN1303 |
Host College |
Loyalist College |
OntarioLearn Course Code |
LO-COMP8167 |
Start Date |
11/01/2024 |
End Date |
02/07/2025 |
Course Fee |
$409.50 |
Hours |
42 |
Pre-requisites |
OLRN1293 |
Course Description |
Students will learn how to create and analyze spreadsheets using PivotTables and PivotCharts, and 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). |
Midterm Exam Format |
No exam requirement |
Final Exam Format |
No exam requirement |
Final Exam Group |
11/01/2024 |
Other Evaluation Details |
Assignments 70%, Capstone Project 30% |
Minimum Passing Mark |
50 |
Mandatory Chats |
No |
Mandatory Group Work |
No |
Other Details |
|
Platform |
Blackboard |
Computer Software Requirements |
Microsoft Excel 2019, 2021, or 365 |
Additional |
This course does not support Mac users. |
Textbook Information |
No textbook required. |
Textbooks
Textbook Title |
|
|
|
|
Author |
|
|
|
|
Publisher |
|
|
|
|
Edition |
|
|
|
|
ISBN |
|
|
|
|
Special Instructions |
|
|
|
|