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