How To Create A Timetable On Excel

I hope that others will benefit from the resources I have developed and used as a classroom teacher, head of department and senior manager working in international education.

Last updated

8 September 2021

I created and developed customised Excel macro enabled workbooks to produce a whole school timetable from scratch. Although I have used commercial packages over the years, I have found that I have a better overview and greater flexibility with these files.
Timetable file makes use of Excel's in built features to help determine optimum solution for option blocks and class scheduling with invalid combinations highlighted.
Once the setup process is completed timetables can be viewed for an individual teacher, class or room.
The price reflects the many hours of work I have spent creating and developing the files and I am happy to assist users who have any questions.
There is also a free version of this resource (containing setup worksheets only):
Whole School Timetable Demo
Follow me on Twitter and Pinterest @hastag73.

Tes paid licenceHow can I reuse this?

Select overall rating

(no rating)

Your rating is required to reflect your happiness.

It's good to leave some feedback.

Something went wrong, please try again later.

Hi, I have just purchased this, but have a couple of questions. Is there any way that I can add further subjects to the options pages, I can only seem to add 13 subjects, but need at least 15.

Empty reply does not make any sense for the end user

Hello again. Can you please explain how the block pages work? I understand going across shows the classes in each year group, but what does going down from A to F mean? And Why does each letter (eg A) have 6 small squared? What does that mean? Thanks

Empty reply does not make any sense for the end user

Had an issue with the macros - now fixed, and working. Very fats response to my query, and very helpful

Empty reply does not make any sense for the end user

Excellent aftercare service. This is a really exceptional system with an awful lot of added extras. I cannot rave enough about it so far.

Empty reply does not make any sense for the end user

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.

Last updated

8 September 2021

I hope that others will benefit from the resources I have developed and used as a classroom teacher, head of department and senior manager working in international education.

Not the right resource?

See other similar resources