Excel Timetable Pivot Table and/or Dashboard
Budget: $10 – $30 AUD
Using the attached File - would like a pivot table (that is also Teams compatible/office online) that completes searches and draws info based on the following (See B4):
Class - e.g. 12HE2.03
3 Letter Initials - e.g. AAA
Room - e.g. R304
Venue - e.g. RC1
changeroom - e.g. AB
If no venue/changeroom - cell states theory
The pivot table would present all info in a weekly format based on Week (Row1), (P1 (Column A), Day (Row 2) which may draw data from several sheets e.g. 10 weeks (presented as a summary on 1 page).
Would like room to be able to add a logo and make the dashboard look professional!
Class - e.g. 12HE2.03
3 Letter Initials - e.g. AAA
Room - e.g. R304
Venue - e.g. RC1
changeroom - e.g. AB
If no venue/changeroom - cell states theory
The pivot table would present all info in a weekly format based on Week (Row1), (P1 (Column A), Day (Row 2) which may draw data from several sheets e.g. 10 weeks (presented as a summary on 1 page).
Would like room to be able to add a logo and make the dashboard look professional!