Build a Digital Skills Matrix in 2024 📊

In this tutorial, we dive into digital lean management by creating a modern skills matrix using Microsoft List. Forget outdated physical boards or clunky Excel sheets—today, we’ll show you how to streamline the process with digital tools that save time, enhance collaboration, and provide real-time updates.

We’ll follow Grady, the Maintenance Manager at Evergreen Renewable Energy (a factice company), as he builds a skills matrix for his team. You’ll see how to set up the matrix from scratch, input data, and organize it for easy tracking of competencies.

What You’ll Learn:

+ How to build a digital skills matrix using Microsoft List for tracking team competencies.
+ How to format and filter the matrix to track skills across employees.
+ How to save time and improve visibility with a digital solution that integrates seamlessly into your lean management system.

By the end of this video, you’ll know how to set up a basic skills matrix, making it easier to manage your team's development and training needs.

This is the first part of a series where we’ll dive deeper into automating updates into your skills matrix, creating visuals with Power BI, integrating data with other tools like capacity management add a bit of copilot magic to your skills matrix.

Don’t forget to like, share, and subscribe for more tips on using digital tools to enhance your lean management practices!

Timestamps:

0:00 - Intro: Why a Digital Skills Matrix?
1:11 - Setting Up the Skills Matrix with Microsoft Lists
1:53 - Create the structure of your Skills Matrix in MS Lists
2:46 - Add Data in your Skills Matrix using the grid view
3:24 - Add Data in your Skills Matrix using form
3:45 - Share the Skills Matrix with your Team for updates
4:07 - Formatting and Organizing your Skills Matrix
4:35 - Group your Skills Matrix per Skill Name for an efficient analysis
5:08 - Create views in MS Lists for customs visualisations
5:55 - Wrap-up and Teasers for Future Videos


👉 Follow Me:
LinkedIn: https://www.linkedin.com/in/frederic-brouillet-consulting/
Website: https://www.digitalleanmanagement.com/
Blog: https://digitalleanmanagement.org/

📢 Engage With Us:
Have questions, tips to share or an idea for a future video? Drop a comment below, and let's get the conversation started!

#DigitalLeanManagement #SkillsMatrix #MicrosoftLists #PowerAutomate #EvergreenRenewableEnergy #LeanTools #ContinuousImprovement #CapacityManagement #MaintenanceTeam #Microsoft365