Course Overview
This hands-on course focuses on best practices to analyse, communicate and manage information with Microsoft Excel to support business and analytical decisions. COMP 2364 starts with navigating and customizing the MS Excel Ribbon interface, the Quick Access Toolbar and using task-specific contextual tabs. Students will engage with ranges, tables, styles, pivot tables, and What-If Analysis tools, via lectures, lab exercises, and assignments outside of class. Key topics covered include creating, editing, formatting, and saving a worksheet, sorting, filtering, slicers, applying formulae, functions, importing and exporting data. Additionally, students will consolidate data across multiple worksheets. COMP 2364 is a required course in the Applied Data Analytics Certificate (ADAC), the Data Visualization with MS PowerBI Microcredential, and an elective in the Applied Database Administration and Design (ADAD) Associate Certificate from Computing Flexible Learning. Upon completion, successful students will know how to master techniques and time saving shortcuts for the daily use as expert end-users of the latest version of MS Excel. This hands-on course focuses on best practices to analyse, communicate and manage information with Microsoft Excel to support business and analytical decisions. COMP 2364 starts with navigating and customizing the MS Excel Ribbon interface, the Quick Access Toolbar and using task-specific contextual tabs. Students make use of ranges, tables, styles, pivot tables, and what if analysis tools, via lectures, lab exercises, and assignments outside of class. Topics include creating, editing, formatting, and saving a worksheet, sorting, filtering, slicers, applying formulae, functions, importing and exporting data, and consolidating data in multiple worksheets. COMP 2364 is a required course in the Applied Data Analytics Certificate (ADAC), the Data Visualization with MS PowerBI Microcredential, and an elective in the Applied Database Administration and Design (ADAD) Associate Certificate from Computing Flexible Learning. Upon completion, successful students will know how to master techniques and time saving shortcuts for the daily use as expert end-users of the latest version of MS Excel.
Prerequisite(s)
Credits
3.0
Domestic fees
$641.71
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Use best practices to create, navigate, and manage MS Excel workbooks.
- Apply Cell Styles, Cell Alignment, Number formatting, and Font options.
- Describe how to enter, edit, format, sort, and filter MS Excel worksheet data.
- Use Relative, Absolute and Mixed cell references.
- Use MS Excel formulas and decision-making functions effectively.
- Audit and troubleshoot MS Excel formulas and functions.
- Create and format data visualizations with charts, including adding and customizing chart elements and styles.
- Explain the differences between tables and ranges in Excel and apply appropriate formatting and data management techniques using both.
- Demonstrate how to use built-in MS Excel Data Analysis Tools: Anova, Solver and Histograms.
- Use the Subtotal feature in Excel to group and summarize data—such as totals, averages, and counts.
- Create and modify MS Excel Pivot Tables and use to analyze data with Pivot Charts and Slicers.
- Perform data analysis tasks, including what-if analysis (Goal Seek, Scenario Manager and Variable Data Tables) and lookup functions.
- Describe MS Excel data modelling processes, and terminology.
- Use advanced logical functions and financial functions
- Analyze datasets and apply appropriate conditional formatting rules in MS Excel to support data interpretation and decision-making.
- Apply Data Tools including data validation rules, data consolidation, and remove duplicate to clean up data and ensure accuracy and consistency
- Import, transform, and export data using Excel's Get & Transform Data tools.
- Examine the features of workbook protection, including methods for securing individual cells and entire worksheets.
- Explore the fundamentals of Excel macros, including how they automate tasks and simplify repetitive actions.
Effective as of Winter 2026
Related Programs
Microsoft Excel (COMP 2364) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Data Analytics
Certificate Part-time
- Applied Database Administration and Design
Associate Certificate Part-time
- Data Visualization with MS Power BI
Microcredential Part-time
Course Offerings
Fall 2026
Below are two offerings of COMP 2364 for the Fall 2026 term.
CRN 50328
Dates
Sep 11 - Dec 11 Loading
- CRN 50328
- $641.71 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 11 - Dec 11 | Fri | 18:00 - 21:00 | Online |
Duration
12 weeks
Instructor
Joanne Atha
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.
- Course is 36 hours synchronous online classes. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 9-12+ hours per week. 3 hours of synchronous class time and 6-9+ hours per week for homework. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. Windows 10 or 11 and Office 2021 or Microsoft 365 is required in order to participate in this course successfully. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. No class October 9 and November 13.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
CRN 36386
Dates
Sep 12 - Dec 12 Loading
- CRN 36386
- $641.71 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 12 - Dec 12 | Sat | 09:00 - 12:00 | Online |
Duration
12 weeks
Instructor
Joanne Atha
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.
- Course is 36 hours synchronous online classes. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 9-12+ hours per week. 3 hours of synchronous class time and 6-9+ hours per week for homework. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. Windows 10 or 11 and Office 2021 or Microsoft 365 is required in order to participate in this course successfully. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. No class October 10 (Thanksgiving) and November 14.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.