Skip to main content

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

Business Systems Course

Subscribe
View cart
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.

Prerequisite(s)

Credits

3.0

Domestic fees

$668.61 - $682.36 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2024

Below are four offerings of BSYS 2051 for the Spring/Summer 2024 term.

CRN 59674

Duration

Tue Jul 09 - Thu Aug 15 (6 weeks)

  • 6 weeks
  • CRN 59674
  • Domestic fees $682.36
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jul 09 - Aug 15 Tue, Thu 18:30 - 21:30 Burnaby SE12 Rm. 324
Instructor

Dave Lazenby

Course outline

View

Domestic fees

$682.36

Important information
  1. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Status

CRN 58573

Duration

Mon Apr 08 - Tue Jun 25 (12 weeks)

  • 12 weeks
  • CRN 58573
  • Domestic fees $682.36
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Apr 08 - Jun 25 N/A N/A Online
May 14 Tue 18:30 - 20:30 Burnaby SE12 Rm. 321
Jun 25 Tue 18:30 - 20:30 Burnaby SE12 Rm. 321
Instructor

Denise Calvert

Course outline

View

Domestic fees

$682.36

Important information
  1. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  2. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  3. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Please note that the exams are written in person at the Burnaby campus. The midterm exam will be on Tue May 14 1830-2030 and the Final exam will be on Tues June 25 1830-2030. 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.
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 66183

Duration

Mon Apr 08 - Tue Jun 25 (12 weeks)

  • 12 weeks
  • CRN 66183
  • Domestic fees $682.36
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Apr 08 - Jun 25 N/A N/A Online
May 14 Tue 18:30 - 20:30 Burnaby SE06 Rm. 107
Jun 25 Tue 18:30 - 20:30 Burnaby SE06 Rm. 107
Instructor

Denise Calvert

Course outline

View

Domestic fees

$682.36

Important information
  1. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  2. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Please note that the exams are written in person at the Burnaby campus. The midterm exam will be on Tue May 14 1830-2030 and the Final exam will be on Tues June 25 1830-2030. 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.
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 57661

Duration

Wed Apr 10 - Wed Jun 26 (12 weeks)

  • 12 weeks
  • CRN 57661
  • Domestic fees $668.61
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Apr 10 - Jun 26 Wed 17:30 - 20:30 Downtown DTC Rm. 374
Instructor

Kaitlyn Minatozaki

Course outline

View

Domestic fees

$668.61

Important information
  1. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Status

In Progress

This course offering is in progress. 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:

  • Indicates programs accepting international students.
  • Indicates programs with a co-op option.

School of Business + Media

  1. Business Administration (General Option)
    Diploma Part-time
  2. Business Administration (Global Studies Option)
    Diploma Part-time
  3. Business Administration (Human Resources Option)
    Diploma Part-time
  4. Business Administration (Management Option)
    Diploma Part-time
  5. Business Administration (Marketing Option)
    Diploma Part-time
  6. Fire Executive Management
    BCIT/Industry Partnership Certificate Part-time
  7. International Trade and Transportation Logistics
    Certificate Part-time
  8. Marketing Management
    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.

Programs and courses are subject to change without notice.