Forum Discussion
AudreySC
Jun 07, 2023Copper Contributor
Excel to plan a training schedule
Hello 🙂 I have a need to create an Excel sheet that will have the name of all the trainers and a list of training planned. The Excel must be for the fiscal year 23-24, so from april to march. I ...
- Jun 08, 2023
AudreySC I attached a very quick example of my thought:
create table and enter training letters. so left side shows trainers A-F and they are teaching (m)ath and (g)ym the first week in april:
If you want to see who is open on Wed 4/5 then use that dropdown and filter by blank:
mtarler
Jun 07, 2023Silver Contributor
I think the easiest most straight forward would be a table with trainers down the left and dates across the top and insert a letter code under each day the trainer is busy (i.e. you can letter code all the different training session/types and add codes for vacations, meetings, or other 'busy' reasons).
AudreySC
Jun 08, 2023Copper Contributor
Hi mtarler 🙂 Thank you for your quick response !
And do you know after that I could I filter the line ? So for example, the trainer is giving math class this week but all the others are giving the gym class. How to know then which trainer is available ? How can I filter my classes based on a letter in the line ?
Kindly,
Audrey
And do you know after that I could I filter the line ? So for example, the trainer is giving math class this week but all the others are giving the gym class. How to know then which trainer is available ? How can I filter my classes based on a letter in the line ?
Kindly,
Audrey
- mtarlerJun 08, 2023Silver Contributor
AudreySC I attached a very quick example of my thought:
create table and enter training letters. so left side shows trainers A-F and they are teaching (m)ath and (g)ym the first week in april:
If you want to see who is open on Wed 4/5 then use that dropdown and filter by blank: