training

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

Hello, I am trying to create a rule for capitalizing the correct value of IT assets for accurate accounting and depreciation purposes. Here are the conditions: IF the asset and is a composite asset meaning built from multiple pieces AND/OR: <tbody> Hardware less than $5,000 INCLUDE VALUE...

Hi Folks, I know this is a excel forum but I really needs some guidance. I am in need of creating a training database. I didn't know whether their is a forum for databases like their is for excel so I thought I would just throw out the question. I am wanting a database to record training...

I'm new to the VBA world so I am unsure of even where to start with this one. What I have is a table with names and how far along those people are in there training in different areas. What I want to do is search that table for everyone who is training/basic in a certain area and copy their...

Hi I have this data set that i need to transpose but i dont know exactly where to start to explain what im trying to do so i will try my best to explain I have a data set that looks like this Book1ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI1Respondent IDCollector IDStart DateEnd DateIP...

All training from 0000000 to 3333333 without repetitions. Ex = 0000000 0000001 Can not have 0000100 = because it is repeating 0000001 It has to stay the perfect matrix of 7 houses

Any recommendations on excel classes for VBA and Macro development? I am finding tons of online courses but I would rather have an in person classroom style training session. Thanks

I've been asked to link about 180 individual (identical) workbooks with one workbook so a central person can monitor the training dates entered by individual users (in their own workbook). I can link one sheet to 180 other workbooks, but I don't think that's the best way as anytime we get some...

I have a training spreadsheet that I am tracking 16 different trainings for about 30 people. I have the dates the training was complete out next to their names. All of the training is annual, so I would like to have the colors change as the exp date approaches. If training was completed...

Hello, My name is Anya and I work for a charity in south east England. Two colleagues and I are interested in receiving training in Excel, but we haven't had any luck with finding anyone locally who can deliver training in the areas we're looking for: Very, very basic introduction to VBA...

Hi I have 2 columns, Names in Column A and Training Course in Column B. Sometimes there will be a duplicate Name and Training Course with a different date in Column C. I'm trying to count the number of UNIQUE names that have taken the Training Course. So if Joe Bloggs has done the H&S...

I hope to explain this correctly. I am needed help with an INDEX/MATCH formula to get the DATE field listed below on [TAB 1]. [TAB 1] <tbody> A B C D E F G 1 ID Product Training1 Training2 Training3 Training4 DATE 2 Mr.X AAA A1 A2 B1 1/5/2018 3 Mr.X BBB B2 B3...

I have this macro in a file: https://1drv.ms/x/s!AihNCPDTynzigUfR7-jTdIvdMLG0 And it doesn't seem to be pulling data from one of the sites. Can anyone help me fix? It seems to be missing Crystal Lake. This file looks at the 2nd tab, and cross references the person, the site, their position...

Looking for some recommendations of online Excel courses to advance myself a bit. If it is advanced Excel dealing with pivots, dashboards, power queries, etc. That would be great! Also looking at introduction to VBA up to Advanced VBA. All VBA knowledge I have, I have pieced together. I would...

We are using Excel for training documentation. When the person being trained completes a training session, he/she will print out the sheet for documentation that they have had the training referenced in the sheet. The person responsible for training, then files the sheet away for future...

Hey, I have a Learning Management System (LMS) online and I can get the excel-reports from online who has done specific courses. I would like to see who has done all the trainings I get the report from so the file looks like: <tbody> Col. A Col. B Col. C Col. D YES Training A Bob Saget NO...

Good Afternoon All, I'm in need of some help on a conditional formatting issue I'm having. What I have is a employee training tracker that I need help with and I would like to use the conditional formatting tool with the green light, yellow light, and red light format. Here is an example of...

Am not good at macros and need experts here to help me. Find below the sample data in sheet named "" <tbody> Name training 1 training 2 training 3 goal actual goal actual goal actual res-1 8 5 8 6 N/A N/A res-2 9 8 8 7 9 4 res-3 6 5 8 3 N/A N/A </tbody> Data to be populated in...

Hi All, I have a list of records <tbody> <tbody> 3 </tbody> <tbody> Youth Services </tbody> <tbody> 3 </tbody> <tbody> Family / Whanau Services </tbody> <tbody> 3 </tbody> <tbody> Family Violence </tbody> <tbody> 3 </tbody> <tbody> Education...