View programs
This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the previous Excel course. 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).
This course is designed to support both Microsoft Excel 2019, 2021 and 365 for Windows, you will not be able to complete the course with any other version of Excel, or with any version of Excel running on a Mac.
Note: Clicking on any of the following links will take you to the program of studies where you can obtain more information or choose additional courses for your shopping cart.
Click here to be informed when this course becomes active
We are currently maintaining a waitlist for this course. If you would like your name added to the waitlist, please contact the Registration Call Centre at 905.721.3000.
Unfortunately, registration is no longer available for this course. Please check the upcoming semester or feel free to browse our website for other courses of interest. You may also click on the link above this course on the course detail page to be notified when a new class is added.
Course Filled to Capacity. Unfortunately, registration is no longer available for this course. Please check the upcoming intakes or feel free to browse our website for other courses of interest.