Microsoft Office is the best software available in the market for the convenience of the user. You can install this software through www.office.com/setup. Its most popular application is MS Excel which helps to create spreadsheet. In this, you can also make a class schedule or work schedule by using a Template or from scratch. In this blog, you will learn how to create a schedule in Excel.
Create a Schedule in Excel – Office.com/setup
To create a schedule, you have to Start Excel application and then open a new workbook. Now, you have to select the cell range and then you should select Merge and Center option in the Alignment group of the Home tab. After this, you have to type “Weekly Schedule” and then you should change the font size to 18 and then just select Middle Align in the Alignment group. Now, you have to select cells and then select the Borders option and from the drop-down in the Font group, you have to select All Borders. Here you have to enter “Daily Start Time”, “Time Interval” and “Starting Date”. Then you have to choose the Select All icon and then you should double-click on the line separating any two columns to resize cells just to fit the contents.
Now, you have to select cell and then enter “TIME.” Then select cell and just enter the time at which you want to begin your schedule. In the next cell, just enter the next interval which you want to list in the schedule.
In another cell, you have to enter the day of the week from which you want to start your schedule. After this, fill the remaining days of the week on the schedule. Here you have to select Row and just make the font Bold and also change the font size to 14.
Then you should select the Select All icon or you can press Ctrl+A and then select Center in the Alignment group of the Home tab. Just select cell and then choose a fill color for the selected cells. You should choose a unique fill color for each cells. Then select the body of the schedule. And from the Borders drop-down, just you have to select All Borders. At the end, you have to Save the schedule.
Save the Schedule as a Template:
For this, you have to select File option and then choose Export option. After this, you have to select change File Type. Now, you have to select Template and then click on Save As option. Here, the Save As dialog box will open. Then you have to open the Custom Office Templates folder. You just have to enter a name for the template and then just select Save option. If you want to use the template in the future, then you have to select the Personal tab on the New screen and then just select the schedule template. This will open as a new workbook. This method will help you to create a schedule in MS Excel and then save the schedule as Template. But if you want any kind of help, then you can visit to the site of MS Office through www.office.com/setup.