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

In this 20-hour self-paced online micro-credential, you will be able to analyze business data by retrieving and matching specific information from large datasets using LOOKUP functions. You will also identify data manipulation techniques like sorting, filtering, and removing duplicates to clean and prepare datasets for effective analysis. Additionally, you use Logical functions to automate data analysis and decision-making and apply text functions to clean and analyze data in Excel. This is designed for learners who could benefit from the advanced Excel functions to analyze calculations on datasets.  

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:

  • Identify data manipulation techniques like sorting, filtering, and removing duplicates to clean and prepare datasets for effective analysis.

  • Use Logical functions to automate data analysis and decision-making.

  • Apply Text functions to clean and analyze data in Excel.

  • Analyze business data by retrieving and matching specific information from large datasets using LOOKUP functions.

  • Work with Excel functions to analyze data and make informed decisions.

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. Working with Advanced Excel Functions to Analyze Data

    2. Discussion Forum

    3. Final Quiz

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $325.00