Course Overview
Following on from COMP 0261, participants are shown intermediate level topics Excel spreadsheet design in this intensive, hands-on seminar. Topics include: enhancing workbooks in the calculating data with advanced formulas, working with tables, charts, sorting and filtering, pivot tables, slicers, pivot charts, and graphic objects. Special techniques to customize and enhance workbooks are also discussed. Successful participants will be prepared to move on to MS Excel Workshop 3, COMP 0269.
Prerequisite(s)
Credits
0.0
Domestic fees
$266.00
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:
- Working with Ranges.
- Use advanced formulas.
- Organize worksheet and table data using various techniques.
- Sort and filter data.
- Create and modify charts. Analyze data using PivotTables, Slicers, and PivotCharts.
- Insert and modify graphic objects in a worksheet.
- Customize and enhance workbooks and the Microsoft Office Excel environment.
Effective as of Spring/Summer 2016
Course Offerings
Spring/Summer 2026
Below is one offering of COMP 0264 for the Spring/Summer 2026 term.
CRN 51242
Dates
Jun 06 Loading
- CRN 51242
- $266.00 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jun 06 | Sat | 09:00 - 17:00 | Online |
Duration
1 day
Instructor
Diana Gerrard
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 7 hours synchronous online class. As this is a one-day workshop and will move quickly in order to cover all of the material, it is important that the student is prepared. Please understand that it is the student’s responsibility to be prepared; to have the prerequisites, hardware and technology required to login and participate. Students must provide their own PC or laptop with Windows 10 or 11 and Excel 2021 or Microsoft 365 in order to participate in this course successfully. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. 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.
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.