Skip to main content

Course details

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

Cost

$237.85

Course offerings

Winter 2023

Below is one offering of COMP 0264 for the Winter 2023 term.

CRN 19347

Duration

Sat Mar 04 (1 day)

  • 1 day
  • CRN 19347
  • $237.85
Class meeting times
Dates Days Times Locations
Mar 04 Sat 09:00 - 17:00 Online
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$237.85

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. 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.
Status

Cancelled

This course offering has been cancelled. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.

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

Contact Us

If you have a question or comment about this course, please complete and submit the form below.

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of MS Excel Workshop 2 (COMP 0264)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.