Highlights

Here are some of the highlights for this micro-credential.

  • No admission requirements, no application process, no pre-requisites, open to anyone

  • Take up to 90 days to complete the course

  • Learn at your own pace using a computer, tablet or smartphone

  • Receive a certificate of course completion and digital badge for successfully completing the course which can be shared on social media (e.g. LinkedIn, Facebook, Twitter), downloaded as a PDF, or even embedded in an email signature

Overview

At the end of this 15-hour self-paced online micro-credential, the learner will be able to apply advanced Excel functions and formulas, including SUMPRODUCT, TEXTJOIN, CONCATENATE, INDEX-MATCH, SUMIF, AVERAGEIF, COUNTIF, DATEDIF, NESTEDIF, and VLOOKUP/XLOOKUP with IF, to solve complex problems and analyze datasets effectively.

Learners who successfully complete the course will earn a digital badge and certificate of course completion that can be downloaded and shared via social media. 

You will have access to the course for 90 days to work through the content.

Learning Outcomes

Upon successful completion of this course, learners should be able to:

  • Use advanced Excel functions and formulas to address complex problems and efficiently examine datasets.

  • Operate advanced Excel functions and formulas to address advanced IF combinations to solve complex problems and analyze datasets effectively.

Curriculum

    1. Land Acknowledgement

    2. Accessibility, Diversity, Equity, and Inclusion (IDEA) Statement

    3. Introduction from Sault College's eLearning Department

    4. What is asynchronous online self-directed learning?

    5. Learner Resources and Supports

    6. Technology Requirements

    7. Privacy and Accessibility Policies

    8. Navigation

    9. Learner Introductions

    10. Discussion Forum: Learner Engagement

    11. Technical Discussion Forum

    12. Frequently Asked Questions

    13. Help & Contact Information

    1. Before we begin...

    2. Welcome and Micro-credential Information

    3. Micro-credential Overview

    4. Learning Outcomes & Goals

    5. Modes of Learning

    1. Lesson Overview and Learning Objectives

    2. Rise File

    3. Discussion on Working with Advanced Excel Functions and IF Combinations

    4. Final Quiz

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $189.99