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 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).
Course Delivery Method:
This course is designed to support Microsoft Excel 2019 for Windows, Microsoft 2021 for Windows, and Microsoft Excel 365 for Windows. Microsoft Excel 2016 for Windows can also be used to complete the course. (You will not be able to complete the course with any other version of Excel or with Excel running on a Macintosh.)
You must be familiar with Windows and file management concepts, and you must have completed COMP 9668 (Excel: Core). (An approved equivalent is also acceptable.)
Hours and Fees
- Contact Information
- OntarioLearn Department