Loading...

Course Description

Microsoft Excel, as part of the Microsoft Office Suite, is an essential workplace readiness skill.

Learn the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. Upon completion of the course, you will have the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually.

Workbook examples covered in the course includes professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

This course is designed to prepare learners to pass the MO-200 Microsoft Excel (Office 2019) certification exam. To earn a Microsoft Office Specialist Associate certification, candidates are required to pass three Microsoft Associate Certification Exams.

 

Course Details

Course Learning Outcomes

By completion of this course, successful learners will be able to:

  • Manage worksheets and workbooks
  • Manage data cells and ranges
  • Manage tables and table data
  • Perform operations by using formulas and functions
  • Create charts and objects

Topics

  • Import data into worksheets
  • Navigate within workbooks
  • Format worksheets and workbooks
  • Customize options and views
  • Configure content for collaboration
  • Manipulate data in worksheets
  • Format cells and ranges
  • Define and reference named ranges
  • Summarize data visually
  • Create and format tables
  • Modify tables
  • Filter and sort table data
  • Insert references
  • Summarize data using Functions
  • Format and modify text
  • Create charts
  • Modify charts
  • Format charts

Who is this course for

This course is designed for 

  • Individuals who want to learn and improve their skills in using Microsoft Excel
  • Individuals aspiring to become Microsoft Office Specialist Associates or Microsoft Office Specialist Experts

Notes

All learners will be provided access to Jasperactive MOS Online, a web-based learning platform.

Prerequisites

None

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Online Asynchronous
Dates
Feb 18, 2025 to Mar 18, 2025
Hours
30.0
Delivery Options
Online Hybrid  
Course Fees
Flat Fee non-credit $499.00
Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Please note: Half hour kickoff session will be held on the Feb 18th at noon

From 2025 onwards, MOS courses will not come with free exam voucher.

To fully participate in the live sessions, students will need: an internet connection and a reliable headset with microphone.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students registered on (or after) the start date will receive access within one day of registration.

Students unfamiliar with online learning are encouraged to take our free Digital Skills for Learning Online course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Section Schedule
Apr 09, 2025 to May 07, 2025
Type
Online Asynchronous
Dates
Apr 09, 2025 to May 07, 2025
Type
Online Synchronous
Days
W
Time
6:00PM to 7:00PM
Dates
Apr 09, 2025 to May 07, 2025
Schedule and Location
View Details
Hours
30.0
Delivery Options
Online Hybrid  
Course Fees
Flat Fee non-credit $499.00
Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Please note there are live sessions included in this course. Dates and times will be updated here as soon as they are confirmed. 

From 2025 onwards, MOS courses will not come with free exam voucher.

To fully participate in the live sessions, students will need: an internet connection and a reliable headset with microphone.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students registered on (or after) the start date will receive access within one day of registration.

Students unfamiliar with online learning are encouraged to take our free Digital Skills for Learning Online course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Section Schedule
Jul 05, 2025 to Aug 02, 2025
Type
Online Asynchronous
Dates
Jul 05, 2025 to Aug 02, 2025
Type
Online Synchronous
Days
Sa
Time
6:00PM to 7:00PM
Dates
Jul 05, 2025 to Aug 02, 2025
Schedule and Location
View Details
Hours
30.0
Delivery Options
Online Hybrid  
Course Fees
Flat Fee non-credit $499.00
Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Please note there are live sessions included in this course. Dates and times will be updated here as soon as they are confirmed. 

From 2025 onwards, MOS courses will not come with free exam voucher.

To fully participate in the live sessions, students will need: an internet connection and a reliable headset with microphone.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students registered on (or after) the start date will receive access within one day of registration.

Students unfamiliar with online learning are encouraged to take our free Digital Skills for Learning Online course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .