- International Fees
International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
This course is divided into two parts: One part builds on the learning from FMGT 3720 and continues to develop Data and Analytics skills using various tools including Excel, Power BI and Tableau. In the other part, Excel is used to analyze data and to build a Financial Model.
Prerequisite(s)
- 50% in FMGT 3720
Credits
5.0
Domestic fees
$961.11
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Perform processes to extract, transform and load data for analysis
- Apply critical thinking principles to decision-making
- Use various tools including Excel, Power BI and Tableau for visual presentation of analysis results
- Create a Pivot table in Excel to analyze Payroll information.
- Create Monthly and Annual Budget Income Statement, Balance Sheet and Cash Flow reports using an Excel model.
- Change the projection data and have the budget reports update to reflect these changes in this model.
- Use appropriate excel functions to link the data in the model.
- Update this model to deal with changes to the underlying assumptions.
Effective as of Winter 2024
Related Programs
Advanced Computer Applications 2 (FMGT 4710) is offered as a part of the following programs:
- Indicates programs accepting international students.
School of Business + Media
- Accounting
Diploma Full-time
- Accounting
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
Course Offerings
Winter 2026
Below are two offerings of FMGT 4710 for the Winter 2026 term.
CRN 82084
Dates
Jan 06 - Apr 14 Loading
- CRN 82084
- $961.11 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 06 - Feb 03 | Tue | 18:00 - 22:00 | Online |
| Feb 10 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 333 |
| Feb 10 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 334 |
| Feb 17 - Feb 24 | Tue | 18:00 - 22:00 | Online |
| Mar 03 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 333 |
| Mar 03 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 334 |
| Mar 10 - Apr 07 | Tue | 18:00 - 22:00 | Online |
| Apr 14 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 334 |
| Apr 14 | Tue | 18:00 - 22:00 | Burnaby NE01 Rm. 333 |
Duration
15 weeks
Instructor
Yasmin Alami
Course outline
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.
- International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- The following dates will be HELD IN-CLASS at the Burnaby Campus and are MANDATORY. Quiz 1: Tuesday, February 10, 2026 (18:00 – 22:00) , Quiz 2: Tuesday, March 3, 2026 (18:00 – 22:00) and Quiz 3: Tuesday, April 14, 2026 (18:00 – 22:00) This is not a self-paced course. You will be expected to be available and online on the posted days and times shown on your registration schedule. It is important you have a stable and consistent internet connection to access course content. Attendance for the in-person exams/classes is MANDATORY. 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
CRN 46361
Dates
Jan 08 - Apr 16 Loading
- CRN 46361
- $961.11 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 08 - Apr 16 | Thu | 18:00 - 22:00 | Burnaby SE12 Rm. 318 |
Duration
15 weeks
Instructor
Yasmin Alami
Course outline
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.
- International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Status
Spring/Summer 2026
Below are two offerings of FMGT 4710 for the Spring/Summer 2026 term.
CRN 52600
Dates
May 11 - Jul 06 Loading
- CRN 52600
- $961.11 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| May 11 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| May 13 | Wed | 18:00 - 22:00 | Online |
| May 20 | Wed | 18:00 - 22:00 | Online |
| May 25 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| May 27 | Wed | 18:00 - 22:00 | Online |
| Jun 01 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| Jun 03 | Wed | 18:00 - 22:00 | Online |
| Jun 08 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| Jun 10 | Wed | 18:00 - 22:00 | Online |
| Jun 15 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| Jun 17 | Wed | 18:00 - 22:00 | Online |
| Jun 22 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| Jun 24 | Wed | 18:00 - 22:00 | Online |
| Jun 29 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
| Jul 06 | Mon | 18:00 - 22:00 | Burnaby SE06 Rm. 107 |
Duration
8 weeks
Instructor
Yasmin Alami
Course outline
Course outline TBD — see Learning Outcomes in the interim.
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.
- International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- Class WILL NOT be held on Monday, May 18th (Victoria Day), and Wednesday, July 1st (Canada Day). The following dates will be HELD IN-CLASS at the Burnaby Campus and are MANDATORY: May 11, 25, June 1, 8,15, 22, 29 and July 6. This is not a self-paced course. You will be expected to be available and online on the posted days and times shown on your registration schedule. It is important you have a stable and consistent internet connection to access course content. Attendance for the in-person exams/classes is MANDATORY. 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
CRN 62383
Dates
Jun 02 - Jul 21 Loading
- CRN 62383
- $961.11 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jun 02 | Tue | 18:00 - 22:00 | Online |
| Jun 06 | Sat | 09:00 - 13:00 | Online |
| Jun 09 | Tue | 18:00 - 22:00 | Online |
| Jun 13 | Sat | 09:00 - 13:00 | Online |
| Jun 16 | Tue | 18:00 - 22:00 | Online |
| Jun 20 | Sat | 09:00 - 13:00 | Online |
| Jun 23 | Tue | 18:00 - 22:00 | Burnaby |
| Jun 27 | Sat | 09:00 - 13:00 | Online |
| Jun 30 | Tue | 18:00 - 22:00 | Burnaby |
| Jul 04 | Sat | 09:00 - 13:00 | Online |
| Jul 07 | Tue | 18:00 - 22:00 | Online |
| Jul 11 | Sat | 09:00 - 13:00 | Online |
| Jul 14 | Tue | 18:00 - 22:00 | Online |
| Jul 18 | Sat | 09:00 - 13:00 | Online |
| Jul 21 | Tue | 18:00 - 22:00 | Burnaby |
Duration
8 weeks
Instructor
Bernadette Edwards
Course outline
Course outline TBD — see Learning Outcomes in the interim.
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.
- International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- The following dates will be HELD IN-CLASS at the Burnaby Campus and are MANDATORY: Quiz 1: Tuesday, June 23, 2026 (18:00 - 22:00), Quiz 2: Tuesday, June 30, 2026 (18:00 - 22:00) and Final: Tuesday, July 21, 2026 (18:00 - 22:00) This is not a self-paced course. You will be expected to be available and online on the posted days and times shown on your registration schedule. It is important you have a stable and consistent internet connection to access course content. The in-person dates/classes are required for students to attend, and have MANDATORY ATTENDANCE. 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
Programs and courses are subject to change without notice.