Roster - How to Create a Roster Template Part 1 - Roster tutorial

http://www.onlinepclearning.com Roster - How to create a roster template. Office Tutorial. How to Create a Roster . Roster template. I'm going to show you how to make this fantastic roster application. Roster information.Excel 2010 tutorial. It contains no code, is not macro enabled. I have used here many features from many of the roster applications I have created over the years. If you have a basic understanding of Microsoft Excel you will be able to create this roster if you follow my simple instructions. Roster instructions You can contact me from my website www.onlinePClearning.com and offer any feedback or suggestions. Let's go through some of its features. You will be able to adjust this to suit any need that you have. I will show you a 24 hour 365 day roster. This is totally variable In this demonstration I have set the roster application to show you 13 periods of 28 day rosters. The interface will take you to any roster period. The dates for all of the rosters are set by entering a start date on the interface. The sheet names are shown on the interface page. If you change the sheet names it will not affect the navigation. It is not necessary to show the tabs. Disable tabs All of the variables are set from a sheet called lists. Go to this sheet. In this instance I have used Codes, you can use times if you wish it will not affect the program. On this sheet we set the shift type the code and the description. Also staff names and other needed information are added here. I will take you to one of the rosters now and show you some of its features. The dates are set from the interface page by simply adding one day all rosters are populated. You can return to the interface page by clicking the button named interface when we add staff or of the additional information about that staff member will automatically be added for you. When we add a shift, we first select the shift type then the drop-down boxes will automatically only contain that type of shift. As you do this the count for each staff member is added automatically on the right, and the count for each day for all staff is added at the bottom. http://www.onlinepclearning.com I'm going to show you how to do this in sections. I will provide you with the formulas that I use. You will be able to pause your video work on your document and then return to viewing when you have completed that particular section.