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 15-hour self-paced online micro-credential, you will gain the skills and knowledge to apply conditional formatting for dynamic data visualization, explore data mining techniques, and automate repetitive tasks using macros. This micro-credential is designed to help you master essential Excel functions, significantly enhancing your efficiency and accuracy in business operations.

By mastering these tools, you will be equipped to perform advanced data analysis, automate tasks, and ensure consistent and accurate data preparation, enabling you to make informed business decisions.

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.

Skills & Competencies

At the end of this micro-credential, you should be able to:

  • Use conditional formatting techniques to enhance dynamic data visualization, enabling the identification of trends and patterns in datasets.

  • Use macros to automate repetitive tasks, streamline workflows, and improve efficiency in the data management process. 3 Apply data mining techniques to extract meaningful insights and improve data-driven decision-making.

  • Apply data mining techniques to extract meaningful insights and improve data-driven decision-making.

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 Conditional Formatting, Macros and Data Mining in Excel

    2. Final Discussion

    3. Final Quiz

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $199.99