Posts

Showing posts from August, 2023

Skill Matrix Tool & Excel Format

Image
Skill Matrix Tool About Skill Matrix: A skill matrix tool , also known as a competency matrix or skill assessment matrix, is a valuable resource for organizations and individuals alike. It helps assess and visualize the skill levels and proficiencies of individuals within a team or organization. Here are some benefits of using a skill matrix tool: Identifying Skill Gaps: A skill matrix tool allows you to clearly see where there are gaps in skills within your team or organization. This can help in planning training and development programs to address these gaps and enhance the overall skill set. Training and Development Planning: With a skill matrix in place, you can create targeted training and development plans for individuals. This ensures that employees receive training that is directly relevant to their current skill levels and future career goals. Succession Planning: Skill matrices can assist in identifying potential successors for critical roles within the organization. By un

Use Vlookup in multiple columns at a time

Image
माइक्रोसॉफ्ट एक्सेल में  30 कॉलम में एक साथ VLOOKUP FORMULA कैसे लगायें।  वीडियो को देखने के लिए यहां क्लिक करें। How to vlookup multiple columns in Excel – example Here is the VLOOKUP formula we have: = VLOOKUP ( I2,A:F, { 4 , 5 , 3 } , FALSE ) But you can’t just insert this formula into J2 cell and hit enter. This would only return one value. What you need to do is select a vertical array that corresponds to the number of columns in your VLOOKUP formula. In our case, we need to select three cells. After that, you can insert the formula to the formula bar and press  Ctrl+Shift+Enter  for Windows ( Command+Return  for Mac) – this will apply an array formula in Excel. Excel Online vlookup to return multiple columns  In Excel Online, VLOOKUP works almost the same way, but you don’t have to select an array and press the combination of buttons to implement it. You can just insert the formula in one cell and press  Enter  => the matching values for the columns specified in the formula w