Learn how to measure progress toward certifying people for various skills. In this video, see how to use Excel to track the progress of musicians as they acquire skills.
(energetic electronic music)…- We got a music school where we teach dance hall,…disco, rai and rapso.…All the stuff that makes your body feel good.…And we're teaching these musicians…that want to be certified in this,…and there are certain requirements…before we send them out into the world…because I don't want to hear from a band leader,…"That fool you sent me last week could not play disco."…It's not what I want to hear.…So, how do we measure the progress…as people take courses, complete them,…and work toward their certification?…We want to see who's completed what.…
One way to do this would be with messy, nested formulas,…pivot tables,…and then you got to integrate that all together.…It's highly manual, tough to troubleshoot, tough to build,…and when you need to change something,…that could be major surgery.…Let me show you a responsible way to do this.…This is done with Power Query and Joins.…So, learn Power Query, learn your Joins, all six of them.…We got nine total students.…
We see courses that Milton has taken,…
Share this video
Embed this video
Video: Tracking progress with Excel