- International Fees
International fees are typically 3.12 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.5
Domestic fees
$942.15
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.
- Indicates programs with a co-op option.
School of Business + Media
- Accounting
Diploma Full-time
- Accounting
Diploma Part-time
- Accounting
Diploma Part-time
- Computerized Accounting
Associate Certificate Part-time
- Finance
Diploma 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
- Financial Planning
Diploma Part-time
Course Offerings
Fall 2024
Below is one offering of FMGT 4710 for the Fall 2024 term.
CRN 42264
Dates
Wed Sep 11 - Wed Dec 04
- 13 weeks
- CRN 42264
- Domestic fees $942.15
Status
In Progress
This course offering is in progress. Please check back next term or subscribe to receive email updates.
Class meeting times
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.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- This is a Bring Your Own Device (BYOD) course. Students are required to use their own laptop during class time. The laptop should be able to be used without the use of a charger, for a minimum of four (4) hours. Computing requirements for the School of Business and Media can be found here: www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf. Information about student discounts on technology products can be found here: www.bcit.ca/it-services/student-discounts/. A desktop computer is not suitable for this course.
Winter 2025
Below is one offering of FMGT 4710 for the Winter 2025 term.
CRN 46361
Dates
Thu Jan 09 - Thu Apr 03
- 13 weeks
- CRN 46361
- Domestic fees $942.15
Status
Full
This course offering is full. Please check back next term or subscribe to receive email updates.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 09 - Apr 03 | Thu | 18:00 - 22:00 | Burnaby SE12 Rm. 318 |
Instructor
Yasmin Alami
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Programs and courses are subject to change without notice.