How to Create a Training Matrix in Excel

Подписаться 11 тыс.

Просмотров 14 тыс.

50% 1

In this video, I'll guide you through multiple methods to create a training matrix in Excel. You'll learn how to use Pivot Table, combine Excel functions, and apply Conditional Formatting to make your desired training matrix. Training matrices help to decide how many employees need training and how much training. Training matrices also help in the development process of an employee. With practical examples and step-by-step instructions, you'll be able to implement this training matrix in your own Excel spreadsheets effortlessly.
👨‍🏫 Instructor: Eshrak Kader
🎥 Editor: Mohammad Ullah
✨ ⯆ Resources:
ALT+O+D - To open the Conditional Formatting dialog box.
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
1:36 - Using Pivot Table
3:57 - Using Combined Formula
8:40 - Applying Conditional Formatting
3:57 - Using Combined Formula
3:21 - Merging Rows to Create Multiple Rows within a Cell
📚 ⯆ DOWNLOAD the workbook here:
www.exceldemy.com/create-a-tr...
🌍 ⯆ Checkout the article here:
www.exceldemy.com/create-a-tr...
💻 ⯆ Similar Videos:
• How to Create a Matrix...
• How to Create a Risk M...
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: / exceldemy
Twitter: / exceldemy
LinkedIn: / exceldemy
🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: exceldemy.com/forum/
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!
🔔 ⯆ Subscribe on RU-vid:
/ @exceldemy2006
#excel #exceltutorial #exceltips #exceltricks

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@Thegregpants 8 месяцев назад

This channel is great, keep at it!!

@urdecisionisurs 3 месяца назад

great video and thank you; how would you add new employees and include a employee status (in case someone leaves); great video

@exceldemy2006 2 месяца назад

Dear, Thanks for your compliment! Your appreciation means a lot to us. You want to add new employees and include employee status in the Training Matrix. We recommend you follow the formula method and enhance the formulas based on your needs. Don't worry! We have improved the existing formula to fulfil your goal. Please check the following: www.exceldemy.com/wp-content/uploads/2024/05/Adding-new-employees-and-including-a-employee-status-in-Training-Matrix.gif You can download the solution workbook: www.exceldemy.com/wp-content/uploads/2024/05/David-L-Porter-SOLVED.xlsx Formula in cell C21: =TRANSPOSE(IF(UNIQUE($C$5:$C$17) = 0, "", UNIQUE($C$5:$C$17))) Formula in cell B22: =IF(UNIQUE($B$5:$B$17) = 0, "", UNIQUE($B$5:$B$17)) The formula for the Matrix: 1. Select cell C22. 2. Apply the following formula: =IFERROR(IF(INDEX($E$5:$E$17, MATCH(1, INDEX(($B$5:$B$17 = $B22) * ($B$5:$B$17 "") * ($C$5:$C$17 = C$21), ), 0)) = "Active", INDEX($D$5:$D$17, MATCH(1, INDEX(($B$5:$B$17 = $B22) * ($B$5:$B$17 "") * ($C$5:$C$17 = C$21), ), 0)), "Employee on a Leave"), "") 3. Copy the formula within the Matrix using the Fill Handle icon.

@HRHồngNhã 18 дней назад

How do you know the rex of colour FFF???

@exceldemy2006 16 дней назад

Hello @HRHồngNhã, The hex color code #FFFFFF represents the color white. In the hexadecimal color system, colors are specified with a combination of six digits, where the first two digits represent the red component, the second two digits represent the green component, and the last two digits represent the blue component. The format is #RRGGBB, where each pair of digits corresponds to the intensity of red, green, and blue (FF is the highest, and 00 is the lowest). To know about other hex color codes, you can easily look them up by searching online. Just type the hex code into Google to find the color and its details. Regards ExcelDemy