Course Description

Improve on your basic knowledge and build spreadsheets that are practical in any industry. Impress your clients or managers with valuable functions, formatting, and data organizing tools.

This course prepares you for the Excel Core Microsoft Office Specialist (MOS) certification exam.

Intermediate-level skills covered:

Create and manipulate Excel workbooks, worksheets, rows, columns, and cells
Format cells using styles, themes, and conditional formatting
Build and edit intermediate formulas and functions using absolute and relative cell references
Organize data using data tools such as sorting, naming ranges, tables, automatic subtotals, and outlining
Create and modify charts and graphics 
Change worksheet views, customize page layouts, and print workbooks
Use summary, statistical, and text functions

Learning Tools and Resources

  • Operating systems Windows as well as Mac/IOS can be used for this course using Microsoft 365.
  • Software not included. Learners are responsible for having access to Microsoft Office 365. 
  • Jasperactive software: The cost of this software is included in the course. Internet access and software download are required.
  • G-Metrix software: The cost of this software is included in the course. Internet access and software download are required.
  • eBook and other resources: A printable eBook and links to video tutorials are provided in Desire2Learn (D2L), the learning management system.

Additional Information

  • It is recommended that learners take COMP9301 Microsoft Excel - Introduction or have equivalent experience prior to taking this course.
  • This course follows an assessment-first approach. You will be assessed at the beginning of the course and then receive an individualized learning plan. This will help you pace yourself in the course activities, measure your progress, and prepare you to demonstrate Excel competencies.
Registration usually closes 24 – 48 hours before the course starts. Register early to secure your seat.
Windmill Microlending

Windmill Microlending can provide affordable loans of up to $15,000 to immigrants and refugees in Canada to pay for the licensing or training you need to get back to your field of work. This is an option for both full-time and part-time students. Windmill is a non-profit charity, since 2005. Please visit windmillmicrolending.org/our-loans for more information.  

 

 

Course Offerings


Any-time Online

A course delivery mode where learning activity takes place at times and locations of the learners own choosing through the use of online communications technologies. Learners are NOT required to participate in any scheduled learning activities, but scheduled exams may be required.

Start/End Date

Jul 10, 2024 - Oct 10, 2024

Hours

30

Price

$375.00 CAD

Online - Asynchronous

Students and instructors participate online. There are no set meeting times.

Start/End Date

Oct 9, 2024 - Jan 9, 2025

Hours

30

Price

$375.00 CAD

Start/End Date

Dec 11, 2024 - Mar 11, 2025

Hours

30

Price

$375.00 CAD

Your cart is currently empty.

Browse Available Courses

Close

  • If you are currently studying in a post-secondary program at BVC, please register for your courses via mybvc to ensure your enrolments and fees are processed appropriately.
  • Cart total based on domestic tuition rates. For information about International Tuition rates please see Additional Fees Apply
  • If you anticipate applying for a student loan, your payment will be refunded to you based on your loan award once your funding has been received by BVC.

We use cookies to ensure that we give you the best experience on our website. Learn more in our privacy policy