Course Overview
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.
Domestic fees
$695.95 - $710.61 See individual course offerings below for actual costs.
International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
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:
- Indicates programs accepting international students.
School of Business + Media
- 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
- Fire Executive Management
BCIT/Industry Partnership Certificate Part-time
Course Offerings
Spring/Summer 2026
Below are two offerings of BSYS 2051 for the Spring/Summer 2026 term.
CRN 58573
Dates
Apr 06 - Jun 25 Loading
- CRN 58573
- $710.61 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Denise Calvert
Course outline
Important information
- ***Exams only will be held in person on campus as follows: Midterm exam Thurs, May 14 1800-2100 and Final Exam Thurs, June 25 1800-2100 Please note that the lecture component for this course is asynchronous, not requiring you to meet 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.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
CRN 57661
Dates
Apr 08 - Jun 24 Loading
- CRN 57661
- $695.95 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Apr 08 - Jun 24 | Wed | 17:30 - 20:30 | Downtown DTC |
Duration
12 weeks
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.