- 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 - 5.5See individual course offerings below for details.
Domestic fees
$918.17 - $961.11 See individual course offerings below for actual costs.
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
Spring/Summer 2025
Below is one offering of FMGT 4710 for the Spring/Summer 2025 term.
CRN 62383
Dates
May 31 - Jul 15 Loading
- CRN 62383
- $942.15 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| May 31 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jun 03 | Tue | 18:00 - 22:00 | Online |
| Jun 07 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jun 10 | Tue | 18:00 - 22:00 | Online |
| Jun 14 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jun 17 | Tue | 18:00 - 22:00 | Online |
| Jun 21 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jun 24 | Tue | 18:00 - 22:00 | Online |
| Jun 28 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jul 05 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jul 08 | Tue | 18:00 - 22:00 | Online |
| Jul 12 | Sat | 09:00 - 13:00 | Burnaby SE12 Rm. 318 |
| Jul 15 | Tue | 18:00 - 22:00 | Burnaby SE12 Rm. 318 |
Duration
7 weeks
Instructor
Bernadette Edwards
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: Saturday, May 31st (09:00 - 13:00), Saturday, June 7th (09:00 - 13:00), Saturday, June 14th (09:00 - 13:00), Saturday, June 21st (09:00 - 13:00), Saturday, June 28th (09:00 - 13:00), Saturday, July 5th (09:00 - 13:00), Saturday, July 12th (09:00 - 13:00) and Tuesday, July 15th (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. This is a Bring Your Own Device (BYOD) course. Please be advised that you will NEED TO BRING YOUR OWN DEVICE to each in-person class. Please ensure that your device has at least four (4) hours of battery life. 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. Students are advised to purchase the textbook, Data Analytics in Accounting, by Dzuranin, Geerts and Lenk, and Wiley Plus Access, available through the BCIT Bookstore, before the start of the course.
Status
Fall 2025
Below are two offerings of FMGT 4710 for the Fall 2025 term.
CRN 42264
Dates
Sep 03 - Dec 10 Loading
- CRN 42264
- $961.11 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 03 - Dec 10 | Wed | 18:00 - 22:00 | Burnaby NE01 Rm. 338 |
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
CRN 52207
Dates
Sep 05 - Dec 12 Loading
- CRN 52207
- $918.17 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 05 - Dec 12 | Fri | 18:00 - 22:00 | Online |
Duration
15 weeks
Instructor
Yasmin Alami
Course outline
Important information
- Internet delivery format.
- International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- Please check the following link to ensure you meet the computer requirements for the class: www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf IMPORTANT NOTE FOR APPLE COMPUTER USERS: Some of the software used in this course is not Mac compatible. You may be able to complete assignments using the Apporto virtual environment, however, this platform can be problematic, and you may need to use a Windows PC to complete the course requirements.
Status
Programs and courses are subject to change without notice.