training

Hi Forum I am try to set up a spreadsheet to count our team's training records. On sheet 1 - I have the data in 4 columns as below <tbody> Date Role Staff Member Name Training (mins) 21/09/2018 Admin Staff 1 20 21/09/2018 Technical Staff 2 120 01/10/2018 Admin Staff 3 30 </tbody> On...

i am developing a employee training tracker tool in vba. In a vba form,i am trying to create a training requisition of the departments. it has fields deptname,trainingname,list of employees ,requireddate,headname. how to display employee id and name in a list box and mulitple select it. how...

My code: Private Sub cmdMOVE_Click() Dim Nam_ID As String Dim fCol As Long Dim wt As Worksheet Set wt = Worksheets("Employee Training Matrix") Nam_ID = cboEN On Error Resume Next With wt fCol = .UsedRange.Find(What:=Me.cboEN, After:=.Range("NAMES"), LookIn:=xlFormulas...

I have a spreadsheet that on the first sheet shows a list of classes down the right column and a list of instructors across the top row. X's are placed in the corresponding cell for instructors that are qualified to teach that class. Second sheet has a table of classes, instructors and their...

The userform is named 'RemoveEmployee'. It has a combobox named 'cboEN'; cboEN lists all the names that are in row 1 within a dynamic named range (“NAMES”) that starts at column H and goes down to the last column with names in it in row 1; when a name is selected from cboEN, and the user hits...

I have spreadsheet with a sheet called "DATA" and a sheet called "TRAINING" in the training sheet I have a personnel ID in C3 and a course ID in D2. I want to search "DATA" for a personnel ID that has done a course in D2 and enter the date on the next due date (some people have done the course...

I have a spreadsheet that takes training attendance for up to 16 modules (there is a 4a and 4b between 1 and 16 also). I have the code written so that when a name is entered, and a user chooses the appropriate modules that have been completed it writes properly to 2 other worksheets. The problem...

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...

Hi, Can someone please help if I have the formula, ='C:\Users\HL02\Desktop\Training Plan\Training Plan IX (F-Day)\[_Template IX Training Plan.xlsx]General'!$F$11 in cell D12 and I want (_Template) to automatically update to the name I cell A12, If A12 was Joe Bloggs...

So I admit Im not great with pivot tables so this is probably something simple I have a large Ledger off all checks written this year Date Written to What For Category Amount when i turn the data into a pivot table the category "training" shows up twice everything...

Please can someone help with my dilemma: I need to notify line managers which of their team are out of date with training requirements Colum A is Line Manager Column B is staff member Columns C-E are for training results, Capacity,Fire and Equality. The only entry in these columns would be...

I am stuck.......... I have 2 training spreadsheets with names, courses & completion dates in row format and I want to have a vba code that automatically pulls data from the 2 worksheets & puts it into the master training spreadsheet which is in column format. it has to first match the course...

I have a formula in a Module that I want to assign to Column H. This formula determines if the training date is past Today() and will either display Not Qualified or Fully Qualified. Column H is dynamic based on the amount of training required for the job selected. I currently have it housed in...

I am copying employee's training worksheets into a single worksheet. From this single worksheet I need to build a Pivot Table so the managers can easily see who has had the training and who has not. I have experimented with VBA code, however it does not pull the data from the Summary worksheet...

Hi Guys, Dont understand what wrong here.. Private Sub ComboBox1_Change() If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _ Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting"...

I am involved in converting ASP e-elearning courses to Storyline. These ASP courses are defined by Excel documents. The Excel documents are broken down to three worksheets: Training, Question and Exam. (I'm focusing today on the Training worksheet.) Storyline allows for the importation of...

I would like some recommendations of some online Excel training (intermediate & Advanced) as well as Power Pivot & query online training it would be appreciated if someone can recommend any (paid or free)

Hi, I am curious whether the MS MOS certification is worth exploring. I am an accountant that does a lot of work with Excel and is in particular branching into PowerBI etc. I have not had any formal training per se and was wondering if it would be worth pursuing training in either the MOS and...

Hi Gurus, I've been trying and failing for too long at this so i'm here for some help. I'm making a training matrix that uses conditional formatting to alert me when training is about to and has expired. So for example, on 01/01/18 Mr. Smith took abrasive wheels training. The training will...

My formula isn't working, and I can't tell why! It's frustrating the crap out of me! Can anyone help? What I'm trying to do: Get the cell to state "COMPLETED" if the person has completed a class. What I'm using Current Workbook Training Records workbook Cell A7 (employee name) in current...