free open source certificated courses
new for autumn 2024
To continue with our ethos of flexible, free tution, we have recently launched our new YouTube Channel with a number of free open-source courses.
Some are just a few minutes long… some a full 4 or 5 hours sessions.
Â
All are FREE
Many are certificated* – soon all will be
All released under a Creative Commons licence – ie please use, share, embed in your own site / learning platform…
*We both regularly watch online tutorials to keep up to date in all things data… but it struck us that it’d be good to be able to have a record of what we’ve done…
Â
…. so we did 🙂
Anyway at the end of each course is a QR code to a Microsoft Form. We only need your name and email to send out a certificate, and it’s all automated by way of Microsoft’s Power Automate -which is just AMAZING!
( there’s a wee video there to show you hopw it works )
Certificated free courses
Introduction to Power BI - Colleges Completion Rates
Introduction to Power BI - Colleges Completion Rates
The first of our Introduction to Power BI - updated for Autumn 2024 - based on a dataset of college completion rates in Scotland. Suitable for Power BI beginners with a good grounding in Excel
- Free
- Creative Commons
- Certificated
Excel Power Query - The Chase
Excel Power Query - The Chase
Introduction to data transformation using Excel Power Query - based on 4 years of statistics from ITV's The Chase
- Free
- Creative Commons
- Certificated
excel zero to excel hero #1
Excel Zero to Excel Hero #1
Suitable for Excel beginners with no prior knowledge required
- Free
- Creative Commons
- Certificated
Starter files for youtube tutorials
The various starter files for our YouTube tutorials can be found here
Introduction to Power BI College Completion Rates starter file
Intro to PBI Completion Rates starter file
Starter file for Excel Power Query – The Chase
The Chase Stats – starter file
Starter file for Excel Zero to Excel Hero #1