This course concentrates on advanced spreadsheet techniques that will transform data into information to improve decision making; designing and creating Decision Support Systems (DSS). In addition to the creation of multiple DSS, students will also incorporate design best practices that will support effective solutions and ensure data quality. Students will utilize analysis tools such as Solver, Scenario Manager, Pivot Tables, and Power View and visualization tools such as Graphs and Pivot Graphs. Students will demonstrate these techniques through industry related assignments and the use of case studies.
Have you taken this course or an equivalent course? Contact the Credit Transfer Office.
Not all courses are offered each term.Fall 2023 registration opens July 24, 2023. Winter 2024 registration opens November 27, 2024.
In person: classes held in person on a campus/site in a classroom/lab/shop/studio for the course duration
Online - Asynchronous: 100% online delivery, no scheduled day or time course requirements with the instructor, assigned due dates
Online - Synchronous: 100% online delivery, scheduled day and time course requirements with the instructor, assigned due dates
Hybrid: any combination of in person, timetabled, on campus, online, and hyflex delivery