Advanced Spreadsheet Applications for SCM

In this Advanced Spreadsheet Applications for SCM course, students will build on their knowledge from COMP 2209 and use advanced functions and features of Microsoft Excel to demonstrate proficiency using spreadsheet software. Students will develop skills to create, format and edit professional worksheets and workbooks using: tables, pivot tables/charts, advanced functions, audit tools, data analysis tools, and macros. Students will cultivate their skills in spreadsheet applications in order to develop comprehensive solutions to business problems; and utilize tools of spreadsheets to enable business leaders to make informed decisions. Students will continue to develop their advanced Excel skills to support a broad understanding of the content included in the Microsoft Office Specialist (MOS) Excel Expert Exam. As part of the course, students will have an opportunity to attempt both the Microsoft Office Specialist (MOS) Excel Associate and Microsoft Office Specialist (MOS) Excel Expert Exams in an effort to obtain Microsoft Office Specialist Certifications (a globally recognized credential). MOS exams must be proctored; therefore, students will be provided with the exam dates/times early in the semester so that they can arrange their schedules accordingly.