View programs
This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course WIND 2282 (Excel Introduction). 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).
Software requirements: Course supports Microsoft Excel 2016, 2019 and 365 for Windows. MAC not supported.
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.
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.
We are currently maintaining a waitlist for this course. If you would like your name added to the waitlist, please contact Enrolment Services at 905.721.3000.