Loading...

Course Description

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

Learn how to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, which include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Upon completion of the course, you will be able to customize Excel environments to meet project needs and to enhance productivity.

This course is designed to prepare learners to pass the MO-201 Microsoft Excel Expert (Office 2019) certification exam. To earn a Microsoft Office Specialist Expert Certification, candidates are required to pass two Microsoft Office Expert exams.

Course Details

Course Learning Outcomes

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

  • Manage workbook options and settings
  • Manage and format data
  • Create advanced formulas and macros
  • Manage advanced charts and tables

Topics

  • Manage workbooks
  • Prepare workbooks for collaboration
  • Use and configure language options
  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering
  • Perform logical operations in formulas
  • Look up data by using functions
  • Use advanced date and time functions
  • Perform data analysis
  • Troubleshoot formulas
  • Create and modify simple macros
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts

Who is this course for

This course is designed for 

  • Individuals who want to improve their skills using Microsoft Excel
  • Individuals aspiring to become Microsoft Office Specialists Experts

Notes

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

Prerequisites

There are no mandatory prerequisites for this course. However, you are required to perform a self-assessment to ensure you meet the requirements to enroll.

Self-assessment for enrolment

Proficient in using Microsoft Excel to manage worksheets, workbooks and data cells, perform operations by using formulas and functions, and create charts and objects.

Recommended Pre-requisites

MOS 120 Microsoft Office Excel Associate

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Online Asynchronous
Dates
Oct 29, 2024 to Dec 03, 2024
Hours
30.0
Delivery Options
Online Asynchronous  
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.

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

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
Jun 03, 2025 to Jul 08, 2025
Type
Online Synchronous
Days
T
Time
12:00PM to 12:30PM
Dates
Jun 03, 2025 to Jun 24, 2025
Type
Online Asynchronous
Dates
Jun 03, 2025 to Jul 08, 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.

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

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 .