courses

Morning all I have a worksheet that contains a list of courses for 2 of my departments, Column C pertain to courses "Department A" have completed and Column G pertain to courses "Department B" have complete. There are over 450 courses detailed in each of these columns, with multiple courses of...

Hi all I've created the this spreadsheet: https://www.dropbox.com/s/y9nykdyne8p04ku/Executive%20PA%20Diploma.xlsx?dl=0 but I need to stop cells relating to the same course from being split when I print the document. I was going to put additional rows between the courses but this...

Hi I know this isn't a unique question but I've been dipping in and out of Excel VBA for over 15 years and not learned much. Most of the role I currently undertake uses Clas modules, collections, dictionaries, arrays etc... It takes me an age to get even the simplest basic tasks done and...

I have a spreadsheet that needs to do X, Y, or Z (which are all various sums of columns of numbers) depending upon two variables: If A=5 and B<>0, then do X. If A=6 and B=0, then do Y. Else, do Z. I have a formula that works correctly without using ArrayFormula: =int(if(and(E2="5 courses each...

I have a large data set that looks like this: <tbody> COURSE START TIME END TIME Conflict Module 2 28/01/2019 16:00 28/01/2019 18:00 TRUE Module 5 13/02/2019 09:00 13/02/2019 12:00 FALSE Module 6 10/10/2019 09:00 10/10/2019 17:00 FALSE Module 10 28/01/2019 16:00 28/01/2019 17:00...

Hi All, I have a real head-scratcher here. I have a workbook that is being used for document training courses. In it, there are two worksheets: The Data worksheet contains the location of training, trainer, trainee and course data. It is formatted to "look nice". The Summary worksheet contains a...

Hiya, I'm hoping somebody can help. I want to use conditional formatting in the end column called all courses complete. I want the end column to be red and say no until all 6 courses have been completed. Once I put all 6 dates into each course column I want the end column to turn green and...

Hi all, I'm required to format .txts into a series of reports. After removing some columns and filtering the courses, this is an example of what I have left (Cols. A to G), with each person having 4 rows of data. The number of people on the report varies. I don't know how to do the final bit...

I am not sure if this is possible, but it seems like theoretically it could be done. I am trying to create a Macro that pops up a userform with a list of courses. Once the user has selected the relevant courses and started the generation process, I would like for the code to be able to first see...

I want to automate something I do manually that takes a long time. I have a spreadsheet with training course data. I need to countif (I think) and show learner name (column B) who have "completed" (column F) a list of 13 courses (column G). I have the names of the 13 courses as they show in the...

Hello, My company has decided they have a small budget for employee development and I was thinking of trying to apply my portion towards a VBA or Excel course. I already do quite a lot of work with Excel and have self taught myself VBA but I thought a course to learn best practices and some new...

Hey, Guys I'm graduating in 1,5 years from an MSc Finance and I'm really looking forward to learn how to write code in VBA in order to be as productive as possible when I start working with excel on a daily basis. I have been looking for courses where I can get this knowledge and, to be honest...

Hello, I have a complex sheet that has hundreds of employee's on who have completed courses. As each month i have to give a list of name to my boss about whose course has been expired (Courses last 2 years). I have the userform all set up, however i can't seem to get the code to search and...

Hi I wonder if someone can help. I work in a school and book courses for other schools. At the moment I've got one spreadsheet set up with a different tab for each Course. On that tab, I enter the delegate name and schools that are attending the training. On the first tab of the...

Hi, I would like to use a combination of a VLOOKUP and a validated list. e.g. the choices in the validation list are either "internal" or "external" (methods of delivering courses). The courses can be delivered either way but we have historical data which tells us what is the usual method...