Advanced Excel Course

Skill Matrix Tool 🔍 Skill Matrix Tool (Summary) A Skill Matrix (or Competency Matrix) is a tool used to assess and visualize the skill levels of individuals or teams. It supports better decision-making, development planning, and resource management. Sample Image of Skill Matrix: Click on below link to download Excel format: { }

  Using VLOOKUP Across Multiple Columns in Excel 🔧 Objective: Use VLOOKUP to return multiple columns of data (e.g., 30 columns) in Excel — efficiently and dynamically. 📝 VLOOKUP Method 1: Using Array Constants `{}` Formula Syntax: = VLOOKUP(B3, 'Data sheet'!B:AE, {2,3,4,5,6,...,31}, 0) Steps: 1. Select the cell where the first result should appear (e.g., D3). 2. Enter the formula above. 3. Press Ctrl + Shift + Enter (only in legacy Excel) to make it an array formula. 4. Drag across 30 columns to populate values. Notes: - This is static — you must type all column numbers manually. - Not ideal for frequent changes. 🔁 VLOOKUP Method 2: Using `COLUMNS()` for Dynamic Return Index Formula Syntax: = VLOOKUP($B3, 'Data sheet'!$B:AE, COLUMNS($B2:D2), 0) Steps: 1. Go to cell D3 (first return column). 2. Type the formula above. 3. Press Enter (no array entry needed). 4. Drag across to 30 columns (e.g., to AG3). 5. Drag the entire row downward to apply ...