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 Hybrid
Dates
Apr 10, 2024 to May 08, 2024
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $499.00
Instructor(s)
  • Serina Kwok
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. 

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.

Type
Online Hybrid
Dates
Jul 06, 2024 to Aug 03, 2024
Hours
30.0
Delivery Options
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. 

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.

Type
Online Asynchronous
Dates
Sep 10, 2024 to Oct 15, 2024
Hours
30.0
Delivery Options
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. 

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 .