Skip to main content

Introduction to Business Data Analytics with MS Excel-MS 365 for Windows BSYS 2051

Business Systems Part-time Studies Course

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.

Prerequisite(s)

Credits

3.0

Cost

$641.04 - $691.66 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2022

Below are two offerings of BSYS 2051 for the Spring/Summer 2022 term.

CRN 60435

Duration

Fri Apr 29 - Fri Jul 22 (12 weeks)

  • 12 weeks
  • CRN 60435
  • $641.04
Class meeting times
Dates Days Times Locations
Apr 29 - Jul 22 Fri 14:30 - 17:20 Burnaby NE01 Rm. 319
Instructor

Lenalda Sutherland

Course outline

View

Cost

$641.04

Important information
  1. Please direct any inquiries to the Program Assistant, Sarah Chanway, at schanway@bcit.ca.
Status

In Progress

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

CRN 59674

Duration

Tue Jun 28 - Thu Aug 04 (6 weeks)

  • 6 weeks
  • CRN 59674
  • $641.04
Class meeting times
Dates Days Times Locations
Jun 28 - Aug 04 Tue, Thu 18:30 - 21:30 Burnaby SE12 Rm. 324
Instructor

Dave Lazenby

Course outline

View

Cost

$641.04

Status

In Progress and Full

This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.

Fall 2022

Below are five offerings of BSYS 2051 for the Fall 2022 term.

CRN 44216

Duration

Tue Sep 06 - Tue Nov 22 (12 weeks)

  • 12 weeks
  • CRN 44216
  • $642.25
Class meeting times
Dates Days Times Locations
Sep 06 - Nov 22 Tue 17:30 - 20:30 Downtown DTC Rm. 375
Instructor

Nadia Graham

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$642.25

Important information
  1. ..
Status

CRN 35638

Duration

Thu Sep 15 - Thu Dec 01 (12 weeks)

  • 12 weeks
  • CRN 35638
  • $655.11
Class meeting times
Dates Days Times Locations
Sep 15 - Dec 01 Thu 18:30 - 21:30 Burnaby SE12 Rm. 318
Instructor

Masoud Jalili

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$655.11

Important information
  1. .
Status

CRN 46245

Duration

Mon Sep 05 - Tue Nov 22 (12 weeks)

  • 12 weeks
  • CRN 46245
  • $691.66
Class meeting times
Dates Days Times Locations
Sep 05 - Nov 22 N/A N/A Online
Oct 11 Tue 18:00 - 20:00 Burnaby
Nov 22 Tue 18:00 - 20:00 Burnaby
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$691.66

Important information
  1. “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. 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 1110 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

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.

CRN 46249

Duration

Mon Sep 05 - Thu Nov 24 (12 weeks)

  • 12 weeks
  • CRN 46249
  • $691.66
Class meeting times
Dates Days Times Locations
Sep 05 - Nov 24 N/A N/A Online
Oct 13 N/A 18:00 - 20:00 Burnaby
Nov 24 N/A 18:00 - 20:00 Burnaby
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$691.66

Important information
  1. This is an asynchronous course that will be held entirely online except for the midterm and the final exams which are held in person at the BCIT Burnaby campus on both October 13 and Nov 24th. 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 1110 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

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.

CRN 47615

Duration

Tue Oct 25 - Thu Dec 01 (6 weeks)

  • 6 weeks
  • CRN 47615
  • $653.93
Class meeting times
Dates Days Times Locations
Oct 25 - Dec 01 N/A N/A Online
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$653.93

Important information
  1. Internet delivery format.
  2. ***Please note this is a compressed courses so it is FAST paced and not suitable for all students *** Important Information: 1. Internet delivery synchronous course format. This is a synchronous course that will be held entirely online. You will be required to log in to the course each week at a specific time. Please check the registration page for the specific dates and times. 2. Learning formats include: online asynchronous, online synchronous, hybrid/blended, and in-class. Please read the information at this link to understand the differences between learning online versus in a real physical classroom. www.bcit.ca/distance/distance-course-formats/ 3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
Status

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings 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

  1. Accounting
    Diploma Part-time
  2. Advanced Business Management
    Certificate Part-time
  3. Advanced Human Resource Management
    Certificate Part-time
  4. Advanced Marketing Management
    Certificate Part-time
  5. Business Administration (General Option)
    Diploma Part-time
  6. Business Administration (Global Studies Option)
    Diploma Part-time
  7. Business Administration (Human Resources Option)
    Diploma Part-time
  8. Business Administration (Management Option)
    Diploma Part-time
  9. Business Administration (Marketing Option)
    Diploma Part-time
  10. Computerized Accounting
    Associate Certificate Part-time
  11. Finance
    Diploma Part-time
  12. Financial Management (Finance Option)
    Certificate Part-time
  13. Financial Management (Professional Accounting Option)
    Certificate Part-time
  14. Financial Planning
    Diploma Part-time
  15. Fire Executive Management
    BCIT/Industry Partnership Certificate Part-time/Distance & Online Learning
  16. International Trade and Transportation Logistics
    Certificate Part-time
  17. Marketing Management
    Certificate Part-time
  18. Operations Management (Facilities Management Option)
    Certificate Part-time
  19. Operations Management (Industrial Engineering Option)
    Certificate Part-time
  20. Operations Management (Management Engineering Option)
    Certificate Part-time
  21. 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.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.