This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course OL702 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). Computer Software Requirements: MS Excel version 2016, 2019, 2021 or 365 for windows. MAC users are not supported in this course.
Sign UpExplore our available course intakes, designed to fit your schedule with flexible start dates. Whether you're studying online or in-class, each session is structured to provide a clear learning pathway.
Find answers to common questions about our courses, registration, fees, and more. Explore the FAQ section for quick solutions to help you get started.
You must be 19 years of age or older to register for an OntarioLearn course. Students 18 years of age or less must possess an Ontario Secondary School Diploma or equivalent to register.
Exams and/or assignments are used in online courses to support learning. They are completed online within the course. The number of assignments and exams will vary by course.
Certificates are not granted for taking individual courses. A copy of an official transcript can show course completion.
Most start January, May, and September and run for 14 weeks. Many courses also start at the beginning of the month. Find start dates for upcoming courses.
Review our textbook website to find textbook and purchasing information.
Review our withdrawal webpage for details on withdrawal dates and how to withdraw.
Our current student website has important information for students, including login information and final grades
Many courses have been approved for equivalency towards Confederation College program courses. Review the equivalency list on our website to find more information.