This course is designed to teach advanced topics of MS Excel. Students will learn how to create and manipulate advanced spreadsheets and be able to manipulate data, work with templates and styles, connecting to external data and links, reviewing and protecting workbooks, custom formats and layouts and creating advanced formulas. The course will also help to prepare students wishing to pursue the MOS certification exams for Excel Expert (Excel Expert 2010 exam 77-888, Excel Expert 2013 exams 77-427 and 77-428). It is recommended students complete COMP 8166 or equivalent before taking this Expert Level. Software: MS Excel 2013 or 2016
It is recommended that students have taken the Excel Specialist/Core course or have equivalent previous experience using Excel.
Computer Software Requirements: MS Excel 2013 or 2016. MAC users cannot currently be supported in this course.