Hey guys, I have written up a checklist in Word.

It's designed to track 50 different training modules that are required to be taken by employees.

There is a box to check by any training modules that have been taken, otherwise it is left blank.Now, I have over 40 employees that need to be doing these training modules, and I don't want to double my efforts by asking repeat questions, etc.

I want to have a way to summarize how many employees have finished a certain training module, like "35/41 finished this training module"

I also want to keep track of who has taken which training modules.Is there a way that I can have these functions written up in something like Excel or Word?

If not, could someone point me in the right direction so that I could have those kind of functions?

If your data was in Excel, there are a few members that could probably help you out. If it's in Word, you may have to go elsewhere.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I could put the data into Excel, no problem.

I am just unsure as to whether or not Excel can handle this type of function.Any ideas?

You could do something like: A B C D E F G 1) Name / Module Mod 1 Mod 2 Mod 3 Mod 4 Mod 5 2) John Smith x x 2 of 5 Modules 3) Harry Green 4) Susan White 5) 6) 1 of 3 Emp.

In cell G2 enter the formula:=COUNTA(B2:F2)&" of "&COUNTA(B$1:F$1)&" Modules"

In cell B6 enter the formula:

=COUNTA(B2:B4)&" of "&COUNTA($A2:$A4)&" Emp."

Drag the formula down & across.

Gives you something to start with.

MIKE

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History