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 14-hour micro-credential, you will learn the essential steps of the business analysis workflow. We will explore effective data acquisition strategies to ensure you gather the most relevant information for your analysis. Additionally, you will gain hands-on experience using Excel to analyze datasets and apply visualization techniques to present your findings. By mastering these skills, you can conduct comprehensive and insightful business analyses.

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 the steps of the business analysis process.

  • Interpret the steps to perform a basic mathematical calculation in Excel.

  • Discuss the purpose of the IF function in Excel.

  • Select steps to troubleshoot and ensure the accuracy of data reliable analysis.

  • Create a pivot table to analyze and compare monthly sales to customers by region using the provided dataset.

  • Explain strategies to troubleshoot and resolve discrepancies to ensure accurate data matching with VLOOKUP.

  • Identify the correct sequence of steps to apply the colour scale in Excel.

  • Apply Excel skills such as converting charts to tables, formatting and cleaning data, performing basic calculations in Excel, using the IF Function, filtering data, using VLOOKUP Function, creating Pivot Tables, Freezing Panes in Worksheets, applying Basic Conditional Formatting and applying Data Visualization Techniques to analyze data.

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. Overview, Unit 1, Unit 2 and Closing

    2. Quiz

    3. Business Scenario

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $275.00