11 Keep the existing filter and add a filter to display classes
5.000 that start at 9:00 AM, 10:00 AM, 11:00 AM, and 12:00 PM.
12 In the Faculty sheet, insert a field on the right side of the
15.000
Room field. Type the label Capacity. Insert a lookup function that looks up the room number, compares it to the lookup table in the Room Capacity worksheet, and returns the room capacity. Make sure the function copies down the entire column.
13 To prepare the workbook for printing, repeat the column
10.000 labels on all pages for the Faculty, Rooms, and Prime Time worksheets.
Select the first three sheet tabs. Set 0.2-inch left and right margins, Landscape orientation, and 95 % scaling.