Microsoft Excel is a powerful tool that can be used to analyse, communicate and manage information. Those with no prior spreadsheet experience will acquire expert level applied skills in the latest version of MS Excel. This instructor lead, hands-on course focuses on best practices used to create meaningful workbooks and how to master the techniques and time saving shortcuts for the daily use of MS Excel. Students learn to use MS Excel Ribbon interface with contextual tabs, Quick Access Toolbar and how to make use of templates, styles, pivot tables, what if analysis tools and macros via lectures, lab exercises and assignments outside of class. Topics include: creating, editing, formatting and saving a worksheet, sorting, filtering, slicers, applying formulae, functions, importing and exporting data, and consolidating data in multiple worksheets. This course is required in the Applied Computer Applications (ACA) Associate Certificate from BCIT Computing Part-time Studies. By the end of this course, successful participants will be expert end users of MS Excel.
COMP 1002 or equivalent knowledge of MS Windows and File Management plus Grade 12 Math or Business Math or equivalent.
3.0
$582.41 - $592.41 See individual course offerings below for actual costs.
Below are two offerings of this course for the Fall 2020 term.
Wed Sep 16 - Wed Dec 02 12 Weeks
| Dates | Days | Times | Locations |
| Sep 16 - Dec 02 | Wed | 18:30 - 21:30 | DTC Online Delivery |
Diana Gerrard
TBD – see Learning Outcomes in the interim
$582.41
Sat Sep 19 - Sat Dec 12 12 Weeks
| Dates | Days | Times | Locations |
| Sep 19 - Dec 12 | Sat | 09:00 - 12:00 | BBY Online Delivery |
Joanne Atha
TBD – see Learning Outcomes in the interim
$592.41
Upon successful completion of this course, the student will be able to:
Effective as of Fall 2020
COMP 2364 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
| Exploring Microsoft Excel 2019 Comprehensive (W/Out Access Card) | |
|---|---|
| Author | Poatsy |
| Publisher | Pearson |
| Copyright | 2020 |
| Binding | Hardback |
| ISBN | 978-0-13545-275-2 |
| Price | $204.95 |
| Required | |
If you are taking this course, but are not taking it through either Distance Education or Online Learning, nor at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Burnaby Bookstore.
| Cei Digital: Exploring Ms Excel 2016 Comp (180 Days) | |
|---|---|
| Author | Poatsy |
| Publisher | Ph |
| Binding | Digital Version |
| ISBN | 978-0-13451-375-1 |
| Price | $61.50 |
| Choose One | |
| Exploring Microsoft Excel 2016 Comprehensive (W/Out Access Card) | |
|---|---|
| Author | Poatsy |
| Publisher | Pearson |
| Copyright | 2017 |
| Binding | Hardback |
| ISBN | 978-0-13447-944-6 |
| Price | $145.95 |
| Choose One | |
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 2364 - Microsoft Excel? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.