skills

Good afternoon all, I've created a Skills Matrix in Excel where engineers listed in columns can select their skill set against each application. They can either choose NONE, BASIC, INTERMEDIATE and ADVANCED (An Example is shown in the Skills Matrix Diagram.jpg attachment. Now, what I want to...

Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...

Hi, I have a table of names as columns and skills matrix as rows for each name. However, I am now trying to move each column (name) to row and repeat all of the skills matrix for each name eg shown below. I have Names listed from Col B to Col W and may keep on increasing and changing and have...

Long shot on this but i really could use some help! I'm looking for a template or someone to help me build an employee directory. I'm not sure if excel is the right medium. Currently I have A Table of contents with names listed and linked to a tab with their info. Basically a self portrait and...

Good Morning, I need help with an equation to finish my skills matrix. I want the calculate the hour rate of pay to increase for every skill greater than 1. Each skill has a total of 4 levels. Level 1 = Basic Level 2 = Performs with help Level 3 = Performs well Level 4 = Trainer So let say...

Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...

Hello, I am trying to figure out how to count unique values in column C (session) based on 3 conditions. <tbody> Name Course Session Status Date John Writing Skills Writing Skills - May 9 Completed 09/05/2018 Kelly Writing Skills Writing Skills - May 9 Completed 09/05/2018 Steve...

Hi guys, I'm a manager at a company where we're not using utilising data enough to demonstrate the impact of the work we're doing. I'd like to do some excel training to develop skills that will help. I'm a fairly basic user that knows some formulas mainly around home finances. Autosum and...

I am looking to broaden my skill set and enhance my career prospects in managing and analyzing data. Besides Excel, what are the next programs to learn or skills to acquire? I see tons of job postings listing out required skills such as SQL, Java, Python, SAS, R, Tableau, etc. What do the...

My code populates names of employees that can work Sunday's. However, I have another column in my table which has skills (i.e. Banking CCTV Clients Driving). etc. I want to add a condition so that my code below will also check if the person who's available on Sunday has the skills in J2 (say...

Hello all, So I am just starting to venture into Excel VBA and I have been able to patch some things together with the help of this site, but I am now stumped as to how to resolve this one issue. I have a large report that has the workshop segments for a specific student registered that semester...

All, I have a large spreadsheet with fishing data on it. Dates, times, tides, water temperature, fish caught, fish targeted etc. It is all in one line by date. Basically it is results (fish) and variables. What would be the easiest way to see which variables are the most important in the...

Which is the best place to enhance the financial modelling skills? If anybody know please suggest me.

First timer, high excel skills but low VBA skills. I have 1000+ .txt files that i need to convert to .xlsm files on a daily basis. I have been searching for options but have not had much luck. I have a R: drive that is holding all of these files i need a macro that can open and save as .xlsm...

Hey guys, I would love it if someone would be able to help me with this issue that I have, as I am struggling to wrap my around which Excel Functions I could use to achieve this... So basically I am setting up a Skills Matrix for our company. Across the top Row 1 all the different skills are...

I've tried goggle but think my search description is wrong... I need to set a format in a given row to only accept data in a given format - DN###### or DNX##### (each of the entries will be unique) or but for some reason I'm struggling and my excel skills are rusty! :(

I have very basic excel skills but am trying to extract the number of times three consecutive cells exceed a particular value - I am trying to identify periods that temperature has exceeded a maximum value for three days or more. Also will need to include days that have not fallen below another...

Hi, I'm putting together a skills matrix in excel, the scoring is from 1 -5 however not all skills relate to each person. If I wanted to work out the average, how do I amend the formula to exclude that cell being part of the formula? =ROUND(AVERAGE(G8:G64),0) Thanks guys!

Hello everybody! I hope this is the right session. I was thinking, apart from an excellent knowledge of the tools, what you think are the skills that a good data analyst should develop? I mean like interpersonal skills for example. The more specific you are the better, i am thinking about this...

Hi all I don't know if what I'm trying to do is possible, or not. I can achieve it manually by looking and typing in the numbers, but I would like to automate it. I've made a guttman chart in excel. Everything is automated except for this part which I'm really struggling with. So at present, I...