- International Fees
International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Course details
The main focus of this course is to develop data analytic skills and demonstrate the ability to manage and present complex data to effectively support business decisions. Students will develop a sound methodology to build "what if" spreadsheet models to assess various business cases. Throughout the course, students will work on business cases in which the design of the spreadsheet is of paramount importance. This course covers advanced Excel formulas, concepts, and applications using larger and more professional worksheets and focusses on the data modeling approach using MS Excel. Topics include built-in functions, charts, transferring data across applications, and using the built-in tools including Pivot Tables, Sparklines, Slicers, and Power Pivots.
Credits
3.0
Cost
$629.50 - $670.36 See individual course offerings below for actual costs.
Course offerings
Fall 2023
Below are four offerings of BSYS 2051 for the Fall 2023 term.
CRN 49514
Duration
Mon Sep 11 - Tue Nov 28 (12 weeks)
- 12 weeks
- CRN 49514
- $670.36
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 11 - Nov 28 | N/A | N/A | Online |
| Oct 17 | Tue | 18:00 - 20:00 | Burnaby SE12 Rm. 324 |
| Nov 28 | Tue | 18:00 - 20:00 | Burnaby SE12 Rm. 324 |
Instructor
Denise Calvert
Course outline
Cost
$670.36
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
-
This asynchronous course is paced with weekly assignment deadlines. Please note that both the midterm and final exams ONLY will be held in person at the BCIT Burnaby campus on Tues, Oct 17 1800-2000 and Tues, Nov 28 1800-2000 both will be in SE12 Room 324. Frequent contributions to asynchronous (not real time) online discussions are recommended to derive full benefit from the course. Students are expected to be familiar with business math concepts as covered in OPMT Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation system.
Status
In Progress
This course offering is in progress. Please check back next term or subscribe to receive email updates.
CRN 44216
Duration
Tue Sep 12 - Tue Nov 28 (12 weeks)
- 12 weeks
- CRN 44216
- $656.61
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 12 - Nov 28 | Tue | 17:30 - 20:30 | Downtown DTC Rm. 375 |
Instructor
Carlos Diaz Teran Salvador
Course outline
Cost
$656.61
Status
In Progress
This course offering is in progress. Please check back next term or subscribe to receive email updates.
CRN 35638
Duration
Thu Sep 14 - Thu Nov 30 (12 weeks)
- 12 weeks
- CRN 35638
- $670.36
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 14 - Nov 30 | Thu | 18:30 - 21:30 | Burnaby SE12 Rm. 320 |
Instructor
Lenalda Sutherland
Course outline
Cost
$670.36
Important information
-
Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
Status
In Progress and Full
This course offering is in progress and full. Please check back next term or subscribe to receive email updates.
CRN 49517
Duration
Tue Oct 24 - Tue Nov 28 (6 weeks)
- 6 weeks
- CRN 49517
- $629.50
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Oct 24 - Nov 28 | N/A | N/A | Online |
Instructor
Ed Bosman
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$629.50
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
-
***Please note this is a compressed course so it is FAST paced and not suitable for all students*** This course is asynchronous, and does not require you to meet each and every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date.
Status
Full
This course offering is full. Please check back next term or subscribe to receive email updates.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Use correct data modeling terminology.
- Apply Relative, Absolute and Mixed cell references.
- Solve financial/business problems using appropriate functions such as PMT, FV, NPER, IRR, NPV and RATE in assessing business cases.
- Develop effective "what if" statements in a spreadsheet to support business decisions.
- Implement advanced spreadsheet functions such as Goal Seek and Scenario Manager to support business decisions.
- Develop a multi-sheet worksheet model capable of sensitivity analyses.
- Prepare, create and apply Templates and Styles in Charts and Tables.
- Organize data lists using filters and PivotTables.
- Summarize data using statistical functions.
- Apply data validation options.
- Analyze data using the Scenario Manager, Data Tables and Goal Seek.
- Use imported and exported data to build models.
- Demonstrate finding and fixing formula errors and 3D formulas.
- Apply basic Macros.
Effective as of Winter 2021
Related Programs
Introduction to Business Data Analytics with MS Excel-MS 365 for Windows (BSYS 2051) is offered as a part of the following programs:
School of Business + Media
- Accounting
Diploma Part-time
- Advanced Business Management
Certificate Part-time
- Advanced Human Resource Management
Certificate Part-time
- Advanced Marketing Management
Certificate Part-time
- Business Administration (General Option)
Diploma Part-time
- Business Administration (Global Studies Option)
Diploma Part-time
- Business Administration (Human Resources Option)
Diploma Part-time
- Business Administration (Management Option)
Diploma Part-time
- Business Administration (Marketing Option)
Diploma Part-time
- Computerized Accounting
Associate Certificate Part-time
- Finance
Diploma Part-time
- Financial Management (Finance Option)
Certificate Part-time
- Financial Management (Professional Accounting Option)
Certificate Part-time
- Financial Planning
Diploma Part-time
- Fire Executive Management
BCIT/Industry Partnership Certificate Part-time
- International Trade and Transportation Logistics
Certificate Part-time
- Marketing Management
Certificate Part-time
- Operations Management (Facilities Management Option)
Certificate Part-time
- Operations Management (Industrial Engineering Option)
Certificate Part-time
- Operations Management (Management Engineering Option)
Certificate Part-time
- Operations Management (Materials Management Option)
Certificate Part-time
Subscribe
Interested in being notified about future offerings of Introduction to Business Data Analytics with MS Excel-MS 365 for Windows (BSYS 2051)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.