- 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 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.
Prerequisite(s)
Credits
0.0
Domestic fees
$260.72
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 2024
Below is one offering of COMP 0269 for the Fall 2024 term.
CRN 32491
Dates
Fri Nov 29
- 1 day
- CRN 32491
- Domestic fees $260.72
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Nov 29 | Fri | 09:00 - 17:00 | Online |
Instructor
Kim Huie
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. 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. Free textbook for COMP 0269 students who have taken COMP 0264 in the same term.
Programs and courses are subject to change without notice.