You can see how the room displayed in Calendar worksheet.You can set your booking period by selecting the month and fill the year.If you are using a table or data set to analyze your information, then you should always use a Pivot Table which will enhance your analytical capabilities as well as save you heaps of time off your daily routine.
Assembling Your Data in Excel Creating a Random Sample Sorting Your Sample Community Q&A This wiki How teaches you how to generate a random selection from pre-existing data in Microsoft Excel.
Random selections are useful for creating fair, non-biased samples of your data collection.
World Possible is a Nonprofit Organization with a mission to connect offline learners to the world's knowledge.
They work to ensure that anyone can access the best educational resources from the web anytime, anywhere, even if they do not have an Internet connection.
I have compiled an interactive tutorial on the 50 different things you can do with an Excel Pivot Table.