- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
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
$260.72
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
Fall 2024
Below is one offering of COMP 0264 for the Fall 2024 term.
CRN 31661
Dates
Sat Nov 23
- 1 day
- CRN 31661
- Domestic fees $260.72
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Nov 23 | Sat | 09:00 - 17:00 | Online |
Instructor
Diana Gerrard
Course outline
Important information
- Internet delivery format.
- 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.
- 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. 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.
Winter 2025
Below is one offering of COMP 0264 for the Winter 2025 term.
CRN 19347
Dates
Sat Mar 01
- 1 day
- CRN 19347
- Domestic fees $260.72
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Mar 01 | Sat | 09:00 - 17:00 | Online |
Instructor
Diana Gerrard
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Internet delivery format.
- 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.
- 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.
Programs and courses are subject to change without notice.