training

Hi guys, I'm a new member here but I've been using the forums for a while now and they've been a big help so far. I'm looking for some help with simplifying a training report I run on a regular basis. I first need to combine 3 reports with VLOOKUPs (or INDEX/MATCH) then I need to split them up...

Hello all, I'm not sure this can be done, but here it goes. I have a sheet with the first column being the interval of months training is due. the second column is the name of that training, as well as another column with contacts or locations where the training happens. The rest of the...

Hi, I need to be able to summarise the table below to show who was doing what hour by hour so that this can be used in a database. Essentially I need to extract an hour by hour view from the large table below to just return this: <tbody> 08:00 name.1 SALES 2 08:00 name.4 TRAINING 08:00...

Good afternoon guys/girls! I am am new to this board and pretty much to excel so I reach out to all you experts for some very much needed help as I need this for my job role. I am recording training for staff at work and require a traffic light system for training dates, I require the...

Hi there! A co-worker has a workbook to keep track of employees' HazMat training classes. When she adds a new employee to the list, their data gets highlighted green, lavendar or blue, depending on what region they're in. The master sheet is called HazMat Training and there are 3 more tabs...

Hello and good day, The company I work for has asked me to do some Excel training at our cooperate headquarters, I was just wondering if anyone out there knows of some free material to speak/train to? I have been asked to do a beginning and intermediate/advance class. I was just looking for a...

Hi all, Been a while, I was looking at making my Training Database a little more use friendly. Currently anytime I would like to check on someones training I either chose one of two forms. I would like a field off to the right that every time I input a keystroke in it searches the table and...

I have a work book with a tab labeled Training with about150 training topics. I then have a calendar with each month its own separate tab. What I would like to do is, put a pull down box of thetraining topics in each day of each month that requires training and then oncea training topic has been...

I'm a special needs Excel user so that Title is a good as I could get for a description. But I added photos to help. Basically, my job requires me to track training for pilots. However, what I would like to do is to have two spreadsheets talk to each other. The first image is a picture of...

Good day, I am looking for a formula to indicate what training a staff member still has to attend. Below is the training schedule. The T indicates the training they need to attend. The A indicates they have attended the training. What I would like is the list of the staff member that still has...

Hey guys, I've been trawling the internet, and it's many excel forums, and am yet to find exactly what I'm looking for! I've been working on a training matrix/schedule and my boss has asked me to come up with a % compliance figure. I really need some help understanding exactly what 'COUNTIF'...

Hi All, I have a sheet with names across the top and then training records for each person below their names. What function/formula do I need to use in order to return a yes/no value if a person has completed a particular training course? Thanks in advance.

Hello I'd like to be able to clear all data validation (including validation comments) from a single selected cell - only in a sheet called Training Log and - only when I click on an assigned button, preceded by a "Are you sure?" Yes/Cancel msgbox. I tried the following code for the deletion...

Good evening all, I have a training table that has columns for Staff name, Rank, unit, company, and then a column for each mandatory training. above the columns I have cells where the end user can enter the duration for training (i.e. 1 yr, 2 yr, .5 yr) which is used by a conditional...

I'm a business professor and use Excel heavily in all my courses. I've written several custom workbooks that automatically grade assignments (using formulas, VBA, conditional formatting, etc.), but the process is clunky. Further, since there are 50 ways to accomplish a given task, there is...

I am creating a workbook for six managers. Every time a manager passes a training course, they receive 2 points. Supposed John Smith has 4 points in cell B3 and he passes another training course, I need to add a 2 to his existing total, giving him 6. Also, if he missed a course, we subtract 1...

Hi, there are so many smart people here, and I was wondering where all of this education comes from? what is the most important basics someone would need to understand programming? to be a programmer does one have to be really good at math? i personally have no formal training, but have...

Evening guys, Been looking at some excel training for sometime and this £20 course popped up from New Skills Academy, syllabus looks ok. it’s CPD certified in the UK, but no hint if anything from Microsoft. My question is are there any excel courses anyone would care to recommend, that are...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Not exactly sure how or why this is going on. We switched out our computer and upgraded Office 2010 with Office Professional Plus 2016. Now our training form isn't working...

I have employee training data in excel sheet, i want to generate reports using vba form,is it possible the columns are training date,department,trainingname,duration,empcode,empname,source can someone help me to do this as i am very amateur to vba coding