Class Timetable using Excel

I need an excel spreadsheet completed so that I can quickly and easily see the below outlined reports. ? I ahve the workinsg of the spreadsheet completed, however I am open to suggestions from experienced excel people to recommending changes. Reports ## v? ? ? ? 7 Groups v? ? ? ? **Subjects; Provision for 20 subjects to be able to be changed** v? ? ? ? **Subjects to be linked to Teacher** v? ? ? ? **Running Total on each subject and each teacher** v? ? ? ? **Running Total for each group for each subject** v? ? ? ? **Running total for each room** ## Deliverables Please see attached mock up of what I was capable of doing. I require more advanced formulas written and reports to be created.