Course Overview
Following on from COMP 0261 plus COMP 0264, participants are shown advanced topics for using Excel in this intensive, hands-on seminar. Topics include: auditing worksheets, analyzing data with what if analysis including goal seek, solver and scenarios. Use of Consolidation and linking techniques. Advanced topics include: basic macros, collaboration, auditing, conditional formatting, data validation, protecting files, revision tracking and importing and exporting data to MS Word. Successful participants in all three One-Day Excel workshops will acquire a solid understanding of how to use MS Excel for a variety of tasks. COMP 0269 will be offered once a year in the Fall (September) term.
Prerequisite(s)
Credits
0.0
Domestic fees
$271.61
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:
- To enhance productivity and streamline Excel workflow.
- To work with multiple Excel worksheets and workbooks.
- To use formula auditing and lookup functions.
- To share workbooks and protect workbooks.
- To locate errors and use data validation.
- To use spark lines on charting.
- Import and export data to MS Word to automate workbook functionality using forms and macros.
- To use Automated Analysis Tools for What-If Analysis.
Effective as of Spring/Summer 2016
Course Offerings
Fall 2026
Below is one offering of COMP 0269 for the Fall 2026 term.
CRN 32491
Dates
Nov 27 Loading
- CRN 32491
- $271.61 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Nov 27 | Fri | 09:00 - 17:00 | Online |
Duration
1 day
Instructor
Kim Huie
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.