Working with Power Query in MS Excel
In this 8-hour micro-credential you will learn about Power Query and how to use this tool to import, transform, and organize data for analysis.
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
In this 8-hour micro-credential you will learn about Power Query and how to use this tool to import, transform, and organize data for analysis. Additionally, you will explore its key features and recognize four important stages (Connect, Transform, Combine, Load), as well as practice linking to data sources, cleaning data, and loading it into Excel. Lastly, you will compare transformation methods for efficiency and create workflows to consolidate data and build interactive reports.
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.
Upon successful completion of this micro-credential, you should be able to:
Use Power Query to connect to various data sources, transform data (e.g., remove duplicates, change data types), and load data into Excel.
Use transformation techniques to optimize data preparation.
Create a data consolidation workflow with interactive reports using Power Query.
Land Acknowledgement
Accessibility, Diversity, Equity, and Inclusion (IDEA) Statement
Introduction from Sault College's eLearning Department
What is asynchronous online self-directed learning?
Learner Resources and Supports
Technology Requirements
Privacy and Accessibility Policies
Navigation
Learner Introductions
Technical Discussion Forum
Frequently Asked Questions
Help & Contact Information
Before we begin...
Welcome and Micro-credential Information
Micro-credential Overview
Learning Outcomes & Goals
Modes of Learning
Discussion Forum
Final Quiz
Thank you
Before you go...
Congratulations