Conestoga College Logo - Home Page

OntarioLearn Course Details Start at 05/14/2024

To register for an OntarioLearn course visit the Continuing Education website.

Course Details
Title  
Course Title Excel Expert
Conestoga Course Code OLRN1303
Host College Loyalist College
OntarioLearn Course Code LO-COMP8167
Start Date 05/14/2024
End Date 08/20/2024
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 05/14/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 #1 Textbook #2 Textbook #3 Textbook #4
Textbook Title
Author
Publisher
Edition
ISBN
Special Instructions
Back To Top