Is it possible to have excel automatically generate a weekly timetable based on various scheduling information?
For instance, let's assume we're scheduling courses for a college. We would have 10 courses, each of which would meet twice a week at different times. If I input all the raw data (course title, date, time, etc.), can excel generate a weekly timetable that will make it easier for me to visually identify conflicts in scheduling?
Seems like a rather simple function, but I can't figure it out for the life of me. I even tried searching for templates, but no luck.
Any help would be greatly appreciated!
For instance, let's assume we're scheduling courses for a college. We would have 10 courses, each of which would meet twice a week at different times. If I input all the raw data (course title, date, time, etc.), can excel generate a weekly timetable that will make it easier for me to visually identify conflicts in scheduling?
Seems like a rather simple function, but I can't figure it out for the life of me. I even tried searching for templates, but no luck.
Any help would be greatly appreciated!