I have some training to organise at work and I'd like to use excel, however I'm looking for some relevant tutorials as I'm not sure the best way to do it.
What I'm trying to achieve is the following: I'd like to be able to generate a 'random' scenario, pulling from a database. Essentially, my colleagues will be answering calls from two potential cohorts of customers, within these cohorts there will be additional scenarios and particular requests my colleagues will have to answer, etc.
Does anyone know a good reference guide to do something like this?
Additionally, and this is more of a 'nice to have' thing, I'd like to be able to output a form my colleagues have to fill out as they do these mock calls, so we can gather feedback and identify areas of weakness. Again, any good guides on this?