Course Overview
This instructor lead, hands-on course continues on from COMP 2010. Students must have prior knowledge and skills at using the basic and intermediate features of MS Excel before starting this Advanced MS Excel course. Participants start at an intermediate level and progress to expert in just 6 lessons while practicing how to create and manage a variety of meaningful spreadsheets. COMP 2362 focuses on the best practices, time saving techniques and how to use MS Excel to create to analyze, communicate and manage information. Lectures, lab exercises in class and assignments outside of class are used for an applied learning experience. Advanced topics include: consolidating data in multiple worksheets templates, dealing with error messages, solver and basic macros. Students who have not completed COMP 2010 should know subtotalling, pivot tables and pivot charts. Participants progress from intermediate to expert in just 6 weeks. This course is an elective in the Applied Computer Information Systems (ACIS) Associate Certificate from BCIT Computing. By the end of this course, successful participants will be expert end users of MS Excel. This course is offered once a year in the Spring (April) term.
Prerequisite(s)
- 60% in COMP 2010
Credits
1.5
Domestic fees
$385.32
International fees are typically 3.25 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:
- 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 Spring/Summer 2026
Related Programs
Microsoft Excel Advanced (COMP 2362) 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 Computer Information Systems (ACIS)
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
Course Offerings
Spring/Summer 2026
Below is one offering of COMP 2362 for the Spring/Summer 2026 term.
CRN 64909
Dates
Jun 12 - Jul 17 Loading
- CRN 64909
- $385.32 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jun 12 - Jul 17 | Fri | 18:00 - 21:00 | Online |
Duration
6 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 18 hours synchronous online classes. 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. Late registration is not permitted.
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.