This could get a little long winded but I will try and explain succinctly.
My department runs education within a hospital. We have one nurse educator per hospital unit and there are 7 units.
Each unit and educator runs their own education sessions each month that apply to only that unit. However, they also run education that may be informative for nurses from other units and it is opened up for them to attend.
I am trying to develop a calendar which shows all education across the hospital that is open to anybody, but also unit specific calendars that show the education available to that unit's staff.
We currently use word and I manually insert education according to these parameters each month which is very time consuming.
I thought excel might offer a better solution and what I would like to achieve is this;
A worksheet per unit (eg; ED, Orthopedics, Surgical etc) where they list all their education running per month. Somehow I need to define each session as unit specific or open to others. The dificulty is that I also need anything that is listed as open to others to feed into the other units pages so it is visable to them.
An organisation wide worksheet; which lists education that is across the board for everyone to attend but not specific to one unit. E.g CPR, Pain management, wound dressing etc. This information also needs to feed into the unit worksheets so it will be visable on their calendar.
A master calendar; which is fed by the other sheets and lists all education across the hospital and which if possible defines if it is open to all or unit specific.
I think it is possible that the master calendar and the organisation wide calendar could be the same thing?
So basically, I would like to be able to print a calendar each month for each unit which shows the education that their educator is running *plus* anything else running within the hospital that they can attend. I also need a master calendar that tracks all the education running each month.
I know that there must be some way to do this but I don't have the skills to figure out how to set it up. Is excel the best solution for creating this calendar?
Thanks in advance.
Rachel
My department runs education within a hospital. We have one nurse educator per hospital unit and there are 7 units.
Each unit and educator runs their own education sessions each month that apply to only that unit. However, they also run education that may be informative for nurses from other units and it is opened up for them to attend.
I am trying to develop a calendar which shows all education across the hospital that is open to anybody, but also unit specific calendars that show the education available to that unit's staff.
We currently use word and I manually insert education according to these parameters each month which is very time consuming.
I thought excel might offer a better solution and what I would like to achieve is this;
A worksheet per unit (eg; ED, Orthopedics, Surgical etc) where they list all their education running per month. Somehow I need to define each session as unit specific or open to others. The dificulty is that I also need anything that is listed as open to others to feed into the other units pages so it is visable to them.
An organisation wide worksheet; which lists education that is across the board for everyone to attend but not specific to one unit. E.g CPR, Pain management, wound dressing etc. This information also needs to feed into the unit worksheets so it will be visable on their calendar.
A master calendar; which is fed by the other sheets and lists all education across the hospital and which if possible defines if it is open to all or unit specific.
I think it is possible that the master calendar and the organisation wide calendar could be the same thing?
So basically, I would like to be able to print a calendar each month for each unit which shows the education that their educator is running *plus* anything else running within the hospital that they can attend. I also need a master calendar that tracks all the education running each month.
I know that there must be some way to do this but I don't have the skills to figure out how to set it up. Is excel the best solution for creating this calendar?
Thanks in advance.
Rachel
