Course Overview
Explore Advanced MS Office Excel 2013 concepts building on the students' proficiency with Excel to enable automation approaches to Business Operations Modelling. Specific focus will be on applying automation tools to Excel within the business modelling framework. Topics include; Inventory and Process modelling using Macro recording and playback, editing Visual Basic for Applications code, adding and using Controls in Excel, and topics involving macro security within Excel.
Prerequisite(s)
- Proficiency with MS Excel 2010/2013 or BSYS 2051.
Credits
3.5
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
Upon successful completion, the student will be able to:
- Model complex Operations Management and Supply Chain Management issues with Excel.
- Automate spreadsheet application tasks using Excel's Macro Recording features.
- Use Visual Basic for Applications to modify and customize Excel macros as needed.
- Investigate process simulation using Monte Carlo simulation and other randomizing techniques in Excel.
Effective as of Spring/Summer 2010
Related Programs
Business Operations Modelling with Excel (BSYS 4051) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Business + Media
- Operations Management (Materials Management Option)
Certificate Part-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.